New training course: Customizing SQL Prompt. Watch now.

How can I stop OPENJSON after CROSS APPLY from showing up on new line

sfrigardsfrigard Posts: 5 Bronze 2
SELECT *
  FROM OPENJSON(@JSON, '$.Doc') AS OJ
       CROSS APPLY OPENJSON(OJ.Value)
         WITH (ID int) AS CAOJ

becomes

SELECT *
  FROM OPENJSON(@JSON, '$.Doc') AS OJ
       CROSS APPLY
       OPENJSON(OJ.Value)
         WITH ( ID INT ) AS CAOJ

Answers

Sign In or Register to comment.