Exporting query results into text file(csv)

Oct 27, 2009 at 7:55 AM

Hi,

 i want to export the query results or stored procedure results in sql server to a text file with comma seperated values (csv).

how it is possible to do that.

  

Oct 27, 2009 at 8:00 AM

This isn't really the forum for this type of question, but what I normally do is cut and paste the results from the Query Analyzer grid into Excel and then save it in CSV format from there.

Oct 27, 2009 at 8:09 AM

that should be automated process. how it can be done ?