I hear what you are saying and I agree that at the end of each record there is a carriage return but I'm wondering why after each column there is...

Query:

DECLARE @query NVARCHAR(max)

SET @query = 'set nocount on; SELECT [weight], [name], [stp] FROM myTable; set nocount off;'

I'm exepcting the results with out all the whitespace at the end of each...