Trailing Spaces and BAT File CMD

[robert_volk]

If you're referring to this thread:

Header and Rows Counted

You need to put SET NOCOUNT ON inside the query statement: sqlcmd -H-1 -S xx.x.xx.x -d MAS_ACT -E -Q "SET NOCOUNT ON; SELECT * from MAS_ACT.dbo.Test_SM_Header " -s "," -o "C:\reporting\SanMar\Header3.txt" If you just need a CSV file output with no headers and no trailing output, the bcp utility will do: bcp "SELECT * from MAS_ACT.dbo.Test_SM_Header " queryout "C:\reporting\SanMar\Header3.txt" -S xx.x.xx.x -T -t ","

You can add the -W parameter to SQLCMD, or use the bcp utility as suggested. If all you're doing in your command script is to output data to CSV, bcp is a better option than SQLCMD.