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 |
|
cuejay
Starting Member
5 Posts |
 Posted - 2002-01-24 : 16:03:34
|
| I have xp_sendmail working but I'm having two problems. (1)the query results are all over the place instead of in a nice comma delimited format like I hoped they'd be. Is this even possible? (2)Is it possible to attach a file other than the specified query results?Quinton J. Wilkerson |
|
|
ToddV
Posting Yak Master
218 Posts |
Posted - 2002-01-24 : 16:27:46
|
quote:
I have xp_sendmail working but I'm having two problems. (1)the query results are all over the place instead of in a nice comma delimited format like I hoped they'd be. Is this even possible?
To some extent yes. Try increasing the @width parameter. If that does not work, Try trimming and Converting thing. If still not good, Try bcp to file. and attach the file.quote:
(2)Is it possible to attach a file other than the specified query results?
Yes. Just include a ';' delimited list in @Attachments. Remember the first will be used for the query results. |
 |
|
|
|
|
|
xp_sendmail