DDL and solution.Is there a better solution? :)--CREATE TABLEcreate table birthday(customer_id int,birthday smalldatetime)--POPULATE TABLEinsert into birthday select 12351,'1980-09-20 00:00:00'union all select 12353,'1989-01-02 00:00:00'union all select 12350,'1976-10-02 00:00:00'union all select 12354,'1951-11-16 00:00:00'union all select 12355,'1952-03-18 00:00:00'union all select 12356,'1952-03-18 00:00:00'union all select 12357,'1974-11-05 00:00:00'union all select 12358,'1976-03-20 00:00:00'union all select 12359,'1988-08-06 00:00:00'union all select 12361,'1989-05-04 00:00:00'union all select 12362,'1943-12-03 00:00:00'union all select 12363,'1970-07-03 00:00:00'union all select 12364,'1953-01-11 00:00:00'--(13 row(s) affected)--GET customers which have in next 2 months birthdaysselect customer_id from birthdaywhere right(convert(nvarchar(20), birthday, 102),5) between right(convert(nvarchar(20), getdate(), 102),5) and right(convert(nvarchar(20),dateadd(day, datediff(day, -60, (getdate())),0), 102),5)