>>Hi All,
>>
>>I am designing a stored procedure that will send an email to all receipients
in a queue. I decided to replace the following line in order to lookup and set the subject of the email dynamically:
>>
>>set @subject = 'IPO # ' + ltrim(rtrim(str(@iIpoId))) + ' Notification'
>>
>>to:
>>
>>set @subject = (select cEmailSubject from webforms.dbo.lookup_emailTemplate where iEmailTemplateID = @iEmailTemplateID)
>>
>>
>>where the cEmailSubject field is:
>>'IPO # ' + ltrim(rtrim(str(@iIpoId))) + ' Notification'
>>
>>In a result the email title is:
>>'IPO # ' + ltrim(rtrim(str(@iIpoId))) + ' Notification'
>>
>>How can I get it to evaluate and display something like :
>>
>>IPO # 1234 Notification
>>
>>Thank you,
>>Daniel
>
>Did you set value for @iIpoId already?
What difference does it make?
--sb--