The code I ended up with is below. With the additional constraints and joins I added, the query only takes 2 to 3 seconds when the TS_CHANGEACTIONS table has 2...

Once again thanks for all the help on this. I went through the posts, took the code from the cte example, changed it to use a temp table and things...

I just noticed the question about size of the table. There are currently 2,069,372 records in it. The counts will end up being over specified date ranges that will encompass...

Thanks for all the input on this. In answer to the question about having 2 re-opens before a ready for build, yes, you could have 2 or even more. It...

Thanks for the helpful directions. I'll start again.

I'm dealing with a table that stores records for states of items as they travel through a workflow. I need to be able...