Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2002-10-23 : 14:41:56
|
| Hell all...I'm currently using xp_sendmail to send the results of a query using the "@ATTACHRESULTS" and "@SEPERATOR" option with a comma so that the users can open the attachment using Microsoft Excel.The problem is that the 2nd row of data contains the dashes you would normally see when running a query in query analyzer like so:ENTRY-DATE------------10/1/0210/3/02Can anyone please tell me how to remove those dashes when running a query?thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-23 : 14:48:28
|
| Other than setting the @no_header parameter I can't think of anything. |
 |
|
|
|
|
|
Removing the D-A-S-H-E-S - - - - - - - -