I am pulling my hair out about this. Whenever I execute the following script with sqlcmd (SQL Server 2005) the output is always on one line even when there are thousands of records returned:
FOR XML AUTO, ELEMENTS
How can I get the output to be formatted with each element on a separate line I tried other specifiers such as EXPLICIT, RAW, etc. but the output always ends up on a single line.