Exporting a table to a csv file with headers on top

[aureliof]

I have maked a stored procedure to export a table on a csv file, first create the table to insert in it the custom header name for the columns, and then insert the data into the same temporal table, and end with a bcp output to the file, 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]

please look at the following article to create a csv file via bcp

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

thanks


This is Signature

http://www.xpherion.com/