I have used it in dozens of situations and in several programming languages ... you how to use recursion in T-SQL, using one of the classic examples of recursion: the factorial calculation.