Timeline for How to use OPENJSON if column is same in SQL?
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 29, 2022 at 16:02 | history | rollback | Charlieface |
Rollback to Revision 1
|
|
| Mar 29, 2022 at 15:39 | comment | added | blac040 | Okay got it. Its working now | |
| Mar 29, 2022 at 15:37 | comment | added | Charlieface |
OK then use the original +, it works fine for me? dbfiddle.uk/… Can you construct a fiddle showing it not working and showing what you would like to see
|
|
| Mar 29, 2022 at 15:35 | comment | added | blac040 | But If values are null, then i don't that property to include in my JSON. Like I tested, with null values, It is not property null. But I don't want that property in json if null | |
| Mar 29, 2022 at 15:30 | comment | added | Charlieface |
You can use CONCAT instead, which ignores nulls
|
|
| Mar 29, 2022 at 15:29 | history | edited | Charlieface | CC BY-SA 4.0 |
added 25 characters in body
|
| Mar 29, 2022 at 15:22 | comment | added | blac040 | If I have null , so It is not working. Then what should we do ? i want to make it more generic | |
| 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 15:59 | history | answered | Charlieface | CC BY-SA 4.0 |