The less loopy the better! I have been using tally tables for a couple of years now but this article really expanded my understanding of how the technique can be applied more broadly. An excellent article – great post Ted! If you still use a lot of loops or cursors in your TSQL code you’re out of touch with best practices. Tally tables, CTE’s (common table expressions), MERGE and “update X” statements are well established methods to convert loops to set based operations and are fundamental skills expected of mid-level TSQL developers. If you don’t have these in your repertoire now, do some reading and find ways to apply these techniques in your very next TSQL coding assignment.