That's not how long the SQL code takes to execute.  Tally based method would crush the OP's kludge especially as their test case is  spanning thousands of days.

19 minutes...

Considering the way the OP asked the question, I'm not...

Hi

This probably a silly question but.....

If I query the size of a table and it shows 20 gigs in size, when I do a select * from that table...

The reason why I wanted you to post your test harness is because you claimed that the Tally solution took 19 MINUTES to the rCTE's 12 MINUTES on that post. ...

Here's another one.  It took 19 minutes vs 12 minutes for the rCTE.  There's no sample data and no time for making any up.  Hopefully the query...

Nope... you may have mentioned it but you've not "shown" anyone...

Here's another one.  It took 19 minutes vs 12 minutes for the rCTE.  There's no sample data and no time for making any up.  Hopefully the query is sound. ...

Any time I've needed to populate a table of sequential numbers, I just done it by brute force. No recursion or fancy stuff. Remember the definition of place...

Heh... when I first heard of "DevOps", my thought was...

Your efforts are much appreciated but the COUNT(*) stuff is going to confuse the very newbies that you're trying to not confuse (by using fnNumbers as the name).

I've also found...

Hi @Grant Fritchey thanks for your reply, we are moving towards backup and restore on AWS RDS but in the meantime I need to use this procedure, can you...

I want to number weeks from April to September for every year, such that week 1 starts 1st of April and ends the following Saturday and week 2 starts...

Hi Andrew-

Thanks for turning me on to Jeff Modon.  Loved his article and sense of humor.

I corrected the length of the @status parameter to 250.

I put the following after...

True enough.  Thanks for the feedback.

Maybe my confusion on this subject is that maybe I've guessed wrong about what you mean by "Minimal" so let's look back at your original question...

What is the minimal...