SHARE
TWEET

Untitled

a guest Jul 24th, 2019 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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"}
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top