Skip to main content

Return to Question

added 312 characters in body
Source Link
marc_s
marc_s
  • 747.8k
  • 180
  • 1.4k
  • 1.5k

From my json data, I need result like this: I want to get two columns distances and durations - can anyone help?

{ 
    "distances": [[0[
                     [0, 6136.2, 6136.2, 0],
                     [4704.7, 0, 0, 4704.7],
                     [4704.7, 0, 0, 4704.7],
                     [0, 6136.2, 6136.2,0]] 0]
                 ],
    "durations": [[0[
                     [0, 554.5, 554.5, 0],
                     [446.4, 0, 0, 446.4],
                     [446.4, 0, 0, 446.4],
                     [0, 554.5, 554.5,0]] 0]
                 ]
}

From my json data, I need result like this: I want to get two columns distances and durations - can anyone help?

{ "distances": [[0,6136.2,6136.2,0],[4704.7,0,0,4704.7],[4704.7,0,0,4704.7],[0,6136.2,6136.2,0]],"durations": [[0,554.5,554.5,0],[446.4,0,0,446.4],[446.4,0,0,446.4],[0,554.5,554.5,0]]}

From my json data, I need result like this: I want to get two columns distances and durations - can anyone help?

{ 
    "distances": [
                     [0, 6136.2, 6136.2, 0],
                     [4704.7, 0, 0, 4704.7],
                     [4704.7, 0, 0, 4704.7],
                     [0, 6136.2, 6136.2, 0]
                 ],
    "durations": [
                     [0, 554.5, 554.5, 0],
                     [446.4, 0, 0, 446.4],
                     [446.4, 0, 0, 446.4],
                     [0, 554.5, 554.5, 0]
                 ]
}
added 3 characters in body; edited tags; edited title
Source Link
marc_s
marc_s
  • 747.8k
  • 180
  • 1.4k
  • 1.5k

sql server SQL Server openjson

So,From my json codedata, I need result like this I: I want to get two columns distances and durations can - can anyone help?

{ "distances": [[0,6136.2,6136.2,0],[4704.7,0,0,4704.7],[4704.7,0,0,4704.7],[0,6136.2,6136.2,0]],"durations": [[0,554.5,554.5,0],[446.4,0,0,446.4],[446.4,0,0,446.4],[0,554.5,554.5,0]]}

sql server openjson

So, my json code, I need result like this I want to get two columns distances and durations can anyone help

{ "distances": [[0,6136.2,6136.2,0],[4704.7,0,0,4704.7],[4704.7,0,0,4704.7],[0,6136.2,6136.2,0]],"durations": [[0,554.5,554.5,0],[446.4,0,0,446.4],[446.4,0,0,446.4],[0,554.5,554.5,0]]}

SQL Server openjson

From my json data, I need result like this: I want to get two columns distances and durations - can anyone help?

{ "distances": [[0,6136.2,6136.2,0],[4704.7,0,0,4704.7],[4704.7,0,0,4704.7],[0,6136.2,6136.2,0]],"durations": [[0,554.5,554.5,0],[446.4,0,0,446.4],[446.4,0,0,446.4],[0,554.5,554.5,0]]}
Source Link
ambako
ambako
  • 15
  • 1
  • 6

sql server openjson

So, my json code, I need result like this I want to get two columns distances and durations can anyone help

{ "distances": [[0,6136.2,6136.2,0],[4704.7,0,0,4704.7],[4704.7,0,0,4704.7],[0,6136.2,6136.2,0]],"durations": [[0,554.5,554.5,0],[446.4,0,0,446.4],[446.4,0,0,446.4],[0,554.5,554.5,0]]}