Get all Birth Days falling within the Date Range using SQL Server

This way

DECLARE @tbl TABLE(Id INT, BirthDate DATETIME)

INSERT INTO @tbl
SELECT 1, '1997-03-15'
UNION ALL
SELECT 2, '1997-05-25'
UNION ALL
SELECT 3, '1997-03-18'

SELECT * FROM @tbl
WHERE REPLACE(BirthDate, DATEPART(YEAR, BirthDate), DATEPART(YEAR, GETDATE())) BETWEEN GETDATE() AND DATEADD(DAY, 15, GETDATE())