Join rows with JSON data stored in table cells using CROSS APPLY
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)
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)