I'm pretty new a creating JSON output form SQL server. I'm having trouble with carriage returns being placed at inappropriate positions in the output when saving the results as a JSON file. Is there a setting or adjustment needed in my SSMS environment?
The data was created using the methods form blog post: https://www.sqlservercentral.com/blogs/how-to-create-multi-object-json-arrays-in-sql-server-2.
,name = JSON_QUERY(name, '$')
,facility_type = JSON_QUERY(facility_type, '$')
,addresses = JSON_QUERY(addresses, '$')
,specialty = JSON_QUERY(specialty, '$')
,plans = JSON_QUERY(plans, '$')
FOR JSON PATH
The sample output data test JSON file attached.
Thank you in advance to any help.
- This topic was modified 1 month, 2 weeks ago by fxferguson. Reason: File load error