Next, you must add the SQL code specifically for a stored procedure, and it must look similar to the first example above. You see, if the stored procedure is to receive parameters, add the ...

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.