You folks should hum a rock at the webmaster for this site to do two things...

1. See if they'll "unspam" your post.
2. See if they can improve the anti-spam bot...

@Jeffrey Williams,

I tested your performance improvements for Peter's code and they're an order of magnitude faster.  Nicely done.  I've also not been able to find a fault in the output...

Lynn Pettis wrote one back in 2009, as well.

https://www.sqlservercentral.com/articles/the-dynamic-tally-or-numbers-table

If I get the chance, I'll add his to the mix, as well.

Anyway, thanks again  for the article and the code,...

Thanks for the very kind feedback, Jason.

Interesting code, Jason.  While I've seen such a thing before, I've not seen many folks that provide a starting value and number...

Wow... it's amazing how fast machines have gotten.  I just tested Sergiy's, Chris', and my fnTally function for simply generating 10 million rows to a bitbucket variable. (No JOIN, though,...

Just a little warning - you should not use a string literal in the function as that will be implicitly converted and could cause cardinality issues. Instead...

Post withdrawn...  I need to stop testing at night.

• This reply was modified 5 years, 4 months ago by Jeff Moden.

Just a little warning - you should not use a string literal in the function as that will be implicitly converted and could cause cardinality issues. Instead - you...

I'll also add that a lot of the "patches" by MS actually take years to fix, if they even bother to fix them at all.

For example, there's been a whole...

True...

There is another calendar format is used in the Scandinavian countries and has an ISO standard. It looks like "yyyyW[0-9][0-9]-[1-7]" the W is a number between 01 and 52...

Heh......

Ok... One more time.  This time, actually verified.

Here's the formula for use with GETDATE().   You can change the two "GETDATE()"s to a column in a table, as well.

            
November 30, 2020 at 4:35 pm
            
#3815219

            
            
                                                
        

Steve, if you're going to use the fnTally function, you need to tell people where to get it.  Since I use it so often, I just put...

I had to take down the previous post because I found a bug in the formula.  Looking for how to fix it.