This doesn't happen often, but I have had this happen a few times when getting data from SQL Server Management Studio, where a row result will not all be on one single row. Is this a result of poor database management or is it an issue with the way I am querying the server?

You can see this particular line splitting into a second row when executed as text.

SQL Server executing as grid, where it appears to all be in a single row, and not broken at the 'SPC' column

data results in excel

CodePudding user response：

This may be due to the Newline('\n') character at an end or somewhere in the text column.

CodePudding user response：

Have you tried cutting down the columns you are returning? See if that changes anything.