How to get Birthday member data from 10,000 of records based on ((from) and ( to date)) .
The From and Todate contains only month and date
example fromdate[08-Aug] todate [24-Aug]
please help me friends i have already spent 2 days for that Thanks in Advance
..................
Ibrahim SiddiquePosted Aug 8, 2017, 6:41 AM
(@DateFrom IS NULL OR alias.MyDate >= @DateFrom) AND
(@DateTo IS NULL OR alias.MyDate < DATEADD(d, 1, @DateTo))