Correction:

select person, birthday

from mytest

where

(datepart(dy, dateadd(mm,@months,@today)) <= datepart(dy, @today) and

(datepart(dy, birthday)>= datepart(dy, @today) or

datepart(dy, birthday)<=datepart(dy, dateadd(mm,@months,@today))))

or

(datepart(dy, dateadd(mm,@months,@today)) >= datepart(dy, @today) and

datepart(dy, birthday) >= datepart(dy, @today) and

datepart(dy,...

quote:

---

Here's Another:

select person, birthday from mytest

where

datepart(dy, birthday)<=(datepart(dy, dateadd(mm,@months,@today)))

and

((datepart(dy, birthday)>= datepart(dy, @today))

or

datepart(dy, birthday)> (datepart(dy, dateadd(mm,@months,@today))))

---