//Here i am giving an example of getting the records of users whose birthdays are between current date and adding 15 days in the current date. I am assuming that the field that contains the birthdate is Bdate. You can give your fieldname insted of it.
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[Get_UpcomingBirthdays]
AS
BEGIN
select your fields,(convert (varchar,(select DateName(month,dateadd(month,month(Bdate),0)-1)),103)+’, ‘+ convert (varchar,day(Bdate),103))
as date,
from TableName
where month(Bdate)=month(getdate())
and day(Bdate)between Day(getdate())
and day(dateadd(day,15,getdate()))
Advertisement
