HI i did a query and i but it in a temp table. And i want to send it a texte file with.

EXEC ('master..xp_cmdshell ''osql -S -U sa -P -q "select * from ##qryExportData" -o F:\Bridge\Export\PrdHrs' + @cur_server_descr + '.txt''')

That it working fine. But i want to know hot to put a startCol and EndCol in the .txt

Ex : i would like my first item to start at the position 1 and end a 10.
My second start at 11 and and at 20.

Is it possible.

Thanks in advance

You need to use bcp or dts (export).