Timeline for How to use OPENJSON if column is same in SQL?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 28, 2022 at 16:33 | vote | accept | blac040 | ||
| Mar 28, 2022 at 16:24 | vote | accept | blac040 | ||
| Mar 28, 2022 at 16:25 | |||||
| Mar 28, 2022 at 16:04 | comment | added | Jeroen Mostert | Do ensure that's really your input and it cannot be changed on the producing end, because duplicate property names are a bad idea (the standard doesn't outright forbid it, but notes the behavior of implementations on receiving it is not consistent). You'd normally expect an array of values, as per your output, but not your input. This would typically indicate a fault in the process generating this output (it could easily happen if the output is manually generated rather than serialized, for example). | |
| Mar 28, 2022 at 15:59 | answer | added | Charlieface | timeline score: 1 | |
| Mar 28, 2022 at 15:45 | comment | added | blac040 | @Larnu , I have edited, can you check | |
| Mar 28, 2022 at 15:44 | history | edited | blac040 | CC BY-SA 4.0 |
added 225 characters in body
|
| Mar 28, 2022 at 15:07 | comment | added | Thom A | Sample data will help us help you. | |
| Mar 28, 2022 at 15:05 | history | asked | blac040 | CC BY-SA 4.0 |