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

🍄 🏰 👻 🌼 👑 💣 🍌 🎮 🐢

Published on Nov 16, 2023 by Loura

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)

Send along a webmention
On Micro.blog
Use an activitypub compatible service, like Mastodon, and find me at @heyloura@heyloura.com
Or give a simple like →