79184799

Date: 2024-11-13 12:07:53
Score: 0.5
Natty:
Report link

You may use a CROSS APPLY

DECLARE @json NVARCHAR(MAX) = '{ "SearchParameters": [ { "LastName": "Smith" }, { "Org": "AAA" }, { "Postcode": "SW1" } ] }';

SELECT k.[key] AS ParameterName, k.value AS ParameterValue
FROM OPENJSON(@json, '$.SearchParameters') AS p
CROSS APPLY OPENJSON(p.value) AS k;
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Jan Suchanek