Timeline for How to parse a JSON with missing property name into a db table
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 14, 2022 at 13:51 | vote | accept | rziya | ||
| Feb 14, 2022 at 13:24 | history | edited | rziya | CC BY-SA 4.0 |
added 10953 characters in body
|
| Feb 14, 2022 at 13:04 | history | edited | rziya | CC BY-SA 4.0 |
deleted 1 character in body
|
| Feb 14, 2022 at 12:44 | comment | added | rziya | Added the expected result table. And corrected the JSON typing error. | |
| Feb 14, 2022 at 12:43 | answer | added | Zhorov | timeline score: 1 | |
| Feb 14, 2022 at 12:38 | history | edited | rziya | CC BY-SA 4.0 |
added 446 characters in body
|
| Feb 14, 2022 at 12:29 | comment | added | Zhorov |
Why projectType is inside the $.data part of the 3rd JSON object - is it a typing error?
|
|
| Feb 14, 2022 at 12:23 | comment | added | Thom A |
What you your expected results here? What was your actual attempt, as just OPENJSON (@JSON) isn't going to return much more than a few rows containing more JSON, as your JSON is nested.
|
|
| S Feb 14, 2022 at 12:10 | review | First questions | |||
| Feb 14, 2022 at 13:56 | |||||
| S Feb 14, 2022 at 12:10 | history | asked | rziya | CC BY-SA 4.0 |