This question already has answers here: SQL Server OPENJSON read nested json (3 answers) How do I get the “key” of an array item in OPENJSON, when using WITH? (1 answer) JSON Object Query SQL Server (2 answers) Closed 32 mins ago. What would be the best way to extract the “answer” out of this […]

This question already has answers here: SQL Server OPENJSON read nested json (3 answers) How do I get the “key” of an array item in OPENJSON, when using WITH? (1 answer) JSON Object Query SQL Server (2 answers) Closed 32 mins ago. What would be the best way to extract the “answer” out of this […]

I want to split the column’s string, and based on the string parts execute multiple inserts in a different table.