Advertisement
Guest User

Untitled

a guest
Jul 24th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. SELECT TOP 1
  2. ID,Code,JSON_QUERY(B.[value]) AS options
  3. FROM OPENJSON(Json) WITH (ID nvarchar(max),Code nvarchar(max),Json nvarchar(max), options NVARCHAR(MAX) AS JSON) D
  4. CROSS APPLY OPENJSON(D.Json) B
  5. ORDER BY B.[key] DESC
  6. FOR JSON PATH, WITHOUT_ARRAY_WRAPPER;
  7.  
  8. {"98934889":"Date: 08/16/2017","5551099988":"This is First comment","5454454545":"This is Second comment"}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement