While I have used BETWEEN in many places, there may be a problem missing the last second or minute of the day when the time is included, and it depends on whether the value is a datetime or a smalldatetime. So something like WHEN ClosedDate >= @FromDate AND < @ToDate, where @ToDate is midnight on the first day of the next quarter, would be more accurate than using BETWEEN.