or if you need up to the last millisecond: DECLARE @dt datetime SELECT @dt = GETDATE() SELECT DATEADD(ms, -3, DATEADD(MONTH, DATEDIFF(MONTH, 0,...
Patel and Ranjitjain, Thanks for the suggestions. They both look like they save a some processing - I will test. johng
We have decided to use this method to accomplish what I think you are. We use a CTE to build the entire list, then count that CTE for total rows...
Separate names with a comma.
