Nicely done, Michael. Real good to see someone actually do a comparison in performance, too.

Since you were kind enough to mention my name, I have to sing the praises of the guy that got me into using Tally/Numbers tables... Adam Machanic.

Since that time, I've run into several DBA's that absolutely refused to allow a permanent Tally table (never mind a date table) to exist but would, strangly enough, allow a temp table... I needed a very high speed method to make one and, well, the rest is history.

Great article and good references... wouldn't mind seeing you do a follow-up article on more Tally table techniques.