Using recursion in stored procedures

(Arthur Fuller) Recursion is one of the most elegant programming constructs in my opinion. I have used it in dozens of situations and in several programming languages. The basic concept of recursion is straightforward: a given chunk of code calls itself until some boundary condition is reached.

I'll demonstrate you how to use recursion in T-SQL, using one of the classic examples of recursion: the factorial calculation.