Skip to content
Advertisement

JSON SQL Server 2016 parse

I have a nested JSON as output form a form and I need to parse it in order to send it in joined tables. I cannot parse some of the data I have in the JSON: labels, rangesValues or body I get NULL anyone encountered this type?

the output should be like

minRange maxRange rangeValues
0 10 1
0 10 2

body sequence

Yes 1

No 2

And what can be done if there are 3 levels nested?

Advertisement

Answer

Seems like, from the discussion in the comments, what you are actually after is this:

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement