-
Output Format File Using xp_sendmail
I want a output file comma delimited as shown below:
ABC,123,45,TEST
I will be using the xp_sendmail to automatically e-mail this attachment out.
Using the @separator=`,` with the xp_sendmail gives me an extra `,` at the end of the file and when I put the `,` in between the columns selected myself(ie AccountNumber, `,`, Quantity, `,`, etc...) I am left with huge amounts of white space between each column(even after using an RTRIM()).
I want to be able to get a file just like when you set the Result Output Format in the Query Options to Comma Delimited!!!!!
Any hidden tricks I do not know about?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|