No problem. It's not *that* big a deal, but you're welcome.

CTEs are our friends. 😉

Have you thought about SQL Server Agent jobs, or just converting them to stored procedures?

SOM 😛

I don't worry about the rankings, Steve. I just worry about getting banned from SSC. 😉

Are insects minerals or vegetables?

Vegetables should really be used for table names.

Thank you for clarifying that, Grant. I was up to 'Zebra' in my table names.

But I haven't started using dinosaur names or insect names...

You're absolutely right, Steve. At that number of rows, hardly anything makes a noticeable difference.

Or, how about this? The cte does the grouping like a temp table, but without any logging overhead.

;with cte as (

SELECT d.name,

COUNT(DISTINCT a.ID) AS DistinctIDs,

SUM(DISTINCT...

The example using a set of SELECT statements linked by UNION ALLs is a single INSERT of the set of all rows. The other example executes a single...

I'm not sure exactly what you mean by basing an index on a stored procedure. Can you give us a little more concrete example of what you...

Barry, for some reason the music from "Twilight Zone" keeps running through my head now.

Have a great weekend guys!

Roy, near as I can tell the conversation following Lynn's dynamic tally table article has been diverting posts away from The Thread.

I've had a lot of moments like that in here, Matt 🙂 I'm not sure if it equates to +1 wisdom, or +1 intelligence, but one day...

INLINE table-valued functions are essentially views with parameters.

Sounds like you need to get with your dba and check permissions.