Stored Procedure to send different email content to different contacts when it is 30 days before the finish date
<p>I need to create a stored procedure in my ms sql server management studio 2008 to send automated email to each email address in the table when it is 30 days before the 'finish date' showing the 'data' value of the same row as the email content. Sample table is as below. I am new to stored procedure, can you please help me with this? Thanks in advance. <a href="https://i.stack.imgur.com/FLe6b.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FLe6b.png" alt="enter image description here"></a></p>