Search results for query: *

When converting a number to text, how can I remove the numeric formatting so that it is just numbers? example: {@AcctNumber} displays as 45789 ToText({@AccountNumber}) displays as 45,789.00. Is there a way to remove the "," and the ".00"? Thank you

I would like to capture errors from an Execute SQL Task (a Stored Procedure). I have a step caled sendmail_failure which is: Declare @Msg VarChar(32) Declare @Sub VarChar(32) Set @Sub = 'DTS Package Failure' + ' ' + Cast(GetDate()as VarChar) execute master.. xp_sendmail @Recipients =...

Sorry for not making it more clear. I would like to capture errors from an Execute SQL Task (a Stored Procedure). I have a step caled sendmail_failure which is: Declare @Msg VarChar(32) Declare @Sub VarChar(32) Set @Sub = 'DTS Package Failure' + ' ' + Cast(GetDate()as VarChar) execute...

I have a DTS package setup with an email (xp_sendmail) sent on failure alerting me that there was a problem. Is there a way to include the cause of the error in the body of the email?

Worked perfectly! Thank you

I have a crystal report that I need to export in a fixed-length ascii format. I need to make the field length, for example, 30 characters regardless of the data in it. How can I do this? I've used "left" to limit the field to 30 char's but that only helps if the length of the text...

Thank you. Like I said: I missed something very simple. The TopN/Sort Group did the trick.

Firstly, I apologize if this has been answered in a previous thread. I looked but couldn't find one that addressed my question. Using CRPro 8.5 I have a report with the group "Dealer" where I summarize loan activity by dealer. I want to be able to group by dealer but sort, within the...