Join rows with JSON data stored in table cells using CROSS APPLY
Thursday, November 16, 2023
You need to use cross apply SELECT sr.Id, sr.OrganizationUnitId, [key] as QuestionTitle, [value] as Answer FROM [dbo].[PbSSurveyResponses] sr CROSS APPLY OPENJSON(sr.Response)