Exporting CSV with custom headers

[aureliof]

I have make a stored procedure to export a table on a csv file, first i insert in a temporal table the custom header name for the columns, and then i insert the data into the same temporal table, but when i check the csv file the headers are in the middle!?, how i can get the custom headers row on top of the file?, the temporal table, gets created in the start of the procedure, then populated and in the end dropped.

thanks.

 

[nomadicalloy]

http://www.simple-talk.com/sql/data...ng-csv-files-using-bcp-and-stored-procedures/

This is Signature

http://www.xpherion.com/