We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
declare @newline varchar(10) declare @body varchar(1000) declare @footer varchar(100) declare @emailid varchar(100) set @newline = CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10) set @footer = 'To change your details please use the following link:' + @newline + 'abc' + @newline + '123' + @newline + 'xyz' set @body = 'The following details need to be updated:' + @newline SELECT @body = @body + (rv_custom_incorrect_org.surname + @newline) FROM rv_custom_incorrect_org WHERE rv_custom_incorrect_org.location_name IS NULL set @body = @body + @newline + @footer set @emailid = (SELECT rv_custom_incorrect_org.email_id FROM rv_custom_incorrect_org WHERE rv_custom_incorrect_org.location_name IS NULL) EXEC msdb.dbo.sp_send_dbmail @recipients = @emailid, @subject = 'Request to Update Your Customer Details', @body = @body, @body_format = 'TEXT'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.