Hi,
I want to populate birthday from database and send a message to that employee.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vikram AgrawalPosted Dec 19, 2014, 4:19 AM
try this
CREATE PROCEDURE dbo.GetBirthdayBuddiesEmails AS Begin
Select * from EmployeeDetails where DATEPART(m, EmployeeDOB)=DATEPART(m,GETDATE()) AND DATEPART(d, EmployeeDOB) = DATEPART(d, GETDATE())
End
This Stored procedure will give you details of employee who have b'day today.
For more details you can visit the following link.
http://www.intstrings.com/ramivemula/articles/sending-automated-emails-asynchronously-using-a-c-windows-service-in-conjunction-with-database-email-records-part-i/
Saineshwar BageriPosted Dec 19, 2014, 1:01 AM
http://www.c-sharpcorner.com/UploadFile/prvn_131971/BirthdayWishScheduler02022006012557AM/BirthdayWishScheduler.aspx
http://www.intstrings.com/ramivemula/articles/sending-automated-emails-asynchronously-using-a-c-windows-service-in-conjunction-with-database-email-records-part-i/