How to populate birthday of employees and send a message

Question

Hi I want to populate birthday from database and send a message to that employee.

Vikram Agrawal · Answer

Hi soudamini try this CREATE PROCEDURE dbo.GetBirthdayBuddiesEmails AS Begin Select * from EmployeeDetails where DATEPART(m EmployeeDOB)=DATEPART(mGETDATE()) 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 Bageri · Answer

This link will help you 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/