Join rows with JSON data stored in table cells using CROSS APPLY

16 Nov 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)