Stored procedure: Simplify comma-separated value (CSV) exports
November 21, 2005[From SearchSQLServer.com]
This tip continues the system stored procedure series with a routine to create a comma-delimited file containing data from several columns.
A comma-delimited data file, also known as a comma-separated value (CSV) file, is typically opened with Microsoft Excel and it often contains a simple data extract. It gets its name from the fact that a comma is placed between adjacent column values within each row. Excel uses each comma as a signal to place the following value in the next column of the worksheet.
The article continues at http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1145349,00.html