Timeline for Trying to read JSON string using SQL Query and OpenJson
Current License: CC BY-SA 4.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 19, 2021 at 3:36 | comment | added | Venkataraman R | @AbdulAleem, for the current JSON, please put the expected output. It will clarify. Based on the answer, you can extrapolate for your needs | |
| Jul 16, 2021 at 19:20 | history | edited | AbdulAleem | CC BY-SA 4.0 |
Added more information
|
| Jul 16, 2021 at 19:18 | comment | added | AbdulAleem | @Venkataraman, that's the problem it has to give me columns and rows dynamically, depending upon the depth and number of fields in jSon. For example, if Continent, Country, States and Cities, so for each City the State, Country and Continent field would be repeated, but the thing is, we don't know the depth and columns exactly, it might change for every jSon string, the Query must be able to run for all the jSon strings without fail - any help my friend? | |
| Jul 16, 2021 at 8:49 | comment | added | Zhorov | @AbdulAleem, this Q&A shows how to read any JSON into list of key-value pairs (EAV format) in SQL Server. | |
| Jul 16, 2021 at 3:57 | comment | added | Venkataraman R | Put your expected output | |
| Jul 16, 2021 at 1:30 | answer | added | ch_g | timeline score: 2 | |
| Jul 16, 2021 at 0:44 | comment | added | Charlieface | Whitespace is free, you know. There's a bunch of nested JSON here, how do you want your results to look? | |
| Jul 16, 2021 at 0:43 | history | edited | Charlieface | CC BY-SA 4.0 |
added 2408 characters in body
|
| Jul 16, 2021 at 0:42 | history | edited | AbdulAleem | CC BY-SA 4.0 |
added 119 characters in body
|
| Jul 16, 2021 at 0:29 | history | edited | AbdulAleem | CC BY-SA 4.0 |
Removed image and added some more text to explain
|
| Jul 16, 2021 at 0:11 | comment | added | Dale K | And add it back as formatted text - at least some of it - unlikely its all needed. | |
| Jul 16, 2021 at 0:09 | history | edited | AbdulAleem | CC BY-SA 4.0 |
Removed image
|
| Jul 16, 2021 at 0:09 | comment | added | AbdulAleem | @Dale do you suggest me to delete the image now buddy? Now its done | |
| Jul 16, 2021 at 0:06 | comment | added | Dale K | No reason to wait... edit it now... | |
| Jul 16, 2021 at 0:06 | comment | added | AbdulAleem | Sorry I didn't know about that, I will make sure next time thank you so much | |
| Jul 15, 2021 at 23:50 | comment | added | Dale K | As per the question guide, please do not post images of code, data, error messages, etc. - copy or type the text into the question. Please reserve the use of images for diagrams or demonstrating rendering bugs, things that are impossible to describe accurately via text. | |
| Jul 15, 2021 at 23:49 | history | edited | Dale K | CC BY-SA 4.0 |
deleted 3 characters in body; edited title
|
| Jul 15, 2021 at 23:49 | history | asked | AbdulAleem | CC BY-SA 4.0 |