Getting along. tdammers answers (112 votes): Recursion is not intrinsically better or worse than loops—each has advantages and disadvantages, and those even depend on the programming language ...

The basic concept of recursion is straightforward: a given chunk of code calls itself until some boundary condition is reached. Arthur Fuller demonstrates how to use recursion in T-SQL.