Jeff Moden (2/25/2012)
Still, I have to give the credit to Itzik for the wonderful and very useful idea especially since it generates virtually no reads. The use of a physical Tally Table will still beat it by a bit in some applications but you simply have to love the "no reads" aspect of Itzik's fine idea.
Yes, the no reads is very hard to not pass up when thinking about tally tables, thanks to Itzik.
/* Anything is possible but is it worth it? */