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.
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.