Wait... how will we know which karthikeyan you are? :w00t:

I missed out on Babylon 5 🙁 It fell during a period of years where I never had time for TV.

Hey Gail, where does your signature line come from? Is that original?

There are a number of versions for what I've heard called a dates table, a calendar table, or a holidays table. They are prepopulated in advance and...

Thanks G... or do you prefer G2 ?? 🙂

Bump it up a notch. The version I sent you was set to 100 thousand rows, not a million.

But yeah, having the tally table already generated SHOULD...

Hey G, how about testing this on your machine so we have apples to apples?

declare @N int;

set statistics time on;

with Tally (N) AS (SELECT TOP 100000 ROW_NUMBER() over (order by...

Great 🙂 Thanks for letting us all know.

Even...

That's good enough reason for me. 😀

Thank you for that candid and incisive commentary, Michael. :hehe:

To be honest, I am rarely trying to do this for over 10-20 rows (just to type up sample data). At that volume, it really doesn't matter. ...

That's because it *is* a variation on your code, Lynn. 😎

I just thought I'd come back with it again, because I can't find anything faster.

I notice you start...

You are absolutely correct. When asking for more information, I just asked for complete text of errors, table schemas...

Many thanks, Jeff. Good to know. In the past (for really big sets) I usually created indexed temp tables and then loaded them, so...

Yeah... just call me "BioHazard Bob"...

All of these are variations on a BioHazard symbol. There are dozens, if not hundreds, out there. I can...