It is fun Chad 😀

I'm thinking I shouldn't post the table structures or anything like that because of our privacy and security restrictions. I may have even stepped over the...

BTW, thank you very much to everyone.

my final result.

DECLARE @Start_Date As Datetime

DECLARE @End_Date As Datetime

DECLARE @TodaysDate As Datetime

SET @Start_Date = '04/01/2010'

SET @End_Date = '07/01/2010'

SET @TodaysDate = GETDATE()

SELECT COUNT(Clients.Client_Number) As Totals

,SUM(CASE WHEN DATEDIFF(yy,...

over an hour

I'm gonna have to talk to the DBA's. It's running around 6 minutes this morning. Up from 9 seconds last night. Here it is. Much better. additional comments welcome if...

I will but I'm not quite finished with it yet. As soon as I get it sorted I'll posted it.

This turned into a nice post. Thanks all

9 seconds total execution time.

9 seconds. 😉

you folks are all fabulous. thank you all.

I had been trying to use the case statement but ran into problems and didn't get the results I was after. I...

I don't waste my time or yours with jokes on forums. I asked because I...

it's not as big as it may appear. it's the ten unions that make it look complicated.

But thanks for you input.