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 |
|
rughanir
Starting Member
4 Posts |
 Posted - 2004-02-13 : 11:31:55
|
| HII really hope someone can help as i dont know what to do from here on. I have a fairly straight forward sp that runs fine alone (ie. in QA or crystal reports) but when i try to use xp_sendmail to email the results, for a couple of lines, some of the numeric fields have changed to something liek this: 1.00000000000e+006 where as i can see the correct figure in query analyser. at first i thought it was the @width paramter buit that didnt make a diff. i also tried to convert one of the numeric fileds to varchar but then i got the output at 10000e+006 in QA itself? dose anyone have any ideas?nb. have tried using both xp_sendmail with and without @attachment |
|
|
|
|
|
xp_sendmail numeric value output