Recommended Reading

Tally Table Articles


Create a Tally Function (fnTally) – Jeff Moden
The “Numbers” or “Tally” Table: What it is and how it replaces a loop – Jeff Moden
Tally Tables in T-SQL – Dwain Camps
Generate a set or sequence without loops – part 1 and part 2 – Aaron Bertrand
Hidden RBAR: Counting with Recursive CTE’s – Jeff Moden
Creative Solutions by Using a Number Table – Greg Larsen
Nasty Fast N-Grams (Part 1) – Alan Burstein

APPLY


Understanding and Using APPLY (Part 1) – Paul White
Understanding and Using APPLY (Part 2) – Paul White
The Cascading (CROSS) APPLY – Chris Morris