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.

The director of the group said to me "Don't ever use recursion in production code." I thought this was a bit of a head-scratcher. What's the word on recursion in production code? Do you use it?