There are dozens of things we can do in SQL that require some type of iteration. “Iteration” means “counters” and “loops” to most people and recursion to others. To those well familiar in the techniques of “Set-based” programming, it means a “Numbers” or “Tally” table, instead.