I've been playing with bcp and xp_sendmessage to try and get certain data sent out as an attached CSV file. Some of the users want to analyse data in Excel.
If I use bcp I can't get the column headers with the data, and if I put the query in xp_sendmessage and send the results as an attachment the file is not in the format that they want.
Either I want to be able to get the column names in bcp or I want to create a decent formatted file in xp_sendmessage.
Can I do this?