When executing a query that generates a large JSON result using FOR JSON PATH, SSMS 22 Preview splits the JSON output into multiple rows in the Results (Messages) grid. In previous SSMS versions (e.g.
The Conditional Split transformation can route data rows to different outputs depending on the content of the data. The implementation of the Conditional Split transformation is similar to a CASE ...