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

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

subscribe via RSS