Oct 09, 2012 12:46 PM|Dan Bracuk|LINK
I suggest creating variables that represent the 1st day of 3 months into the future and the first day 4 months in the future. Then your sql would be
and DateOfService >= @var1
and DateOfService < @var2
This approach will probably run faster too, especially if DateOfService is indexed.