Get Birthday reminder Sql Query ignoring year.
This code example is useful to get all the rows from SQL Server between tow given dates and ignoring year. This is useful when you want to get all the records for next week, 15 Days , one month or your specified date.
In this example we have to use GetDate() DatePart() function to to fetch all the records falling between specified dated.
select * from where datepart(dayofyear,
) between datepart(dayofyear,getdate()) and