how to run a stored procedure from xp_sendmail

[Lakshmi]

hi,

I trying to call a stored procedure with parameter from xp_sendmail. I am getting syntax error. Is there anyone who can help me?
here is the code I am using...

execute master.dbo.xp_sendmail @recipients='lakshmip@oasisnetwork.com', @message='Leads Information',
@query='Execute LeadDistribution..sp_sendmailB '+@AssToID''

[gopal]

Hi,

I believe we cannot manuipulate strings while passing value for parameter. But we can move this value into temp variable and pass it into stored procedure. For example, assuming @assToid is integer


declare @strquery varchar(50)
select @strquery = 'Execute LeadDistribution..sp_sendmailB ' + convert(char,@AssToID)
execute master.dbo.xp_sendmail @recipients='lakshmip@oasisnetwork.com', @message='Leads Information',
@query=@strquery

Regards,
Gopal


------------
Lakshmi at 1/22/01 2:12:43 PM

hi,

I trying to call a stored procedure with parameter from xp_sendmail. I am getting syntax error. Is there anyone who can help me?
here is the code I am using...

execute master.dbo.xp_sendmail @recipients='lakshmip@oasisnetwork.com', @message='Leads Information',
@query='Execute LeadDistribution..sp_sendmailB '+@AssToID''