Skip to content
Hey Loura
RSS
About
Archive
Photos
Bookmarks
+
tales from the high seas of the indie web
Curated logs
Nov 16
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 …