jez.lisle (5/7/2010)
WHERE C.id NOT IN (74, 75)
AND (DATEADD(DD, DATEDIFF(DD, 0, ASV.booking_date), 0) = DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), 0))
AND ASV.completion_date IS NOT NULL
AND ASV.booking_date > DATEADD(Day, DATEDIFF(Day, 0, GETDATE()), 0)) -- For current Day
AND ASV.booking_date > DATEADD(Month, DATEDIFF(Month, 0, GETDATE()), 0)) -- For current Month
-- Cory