Recursion in T–SQLUsing recursion in stored proceduresA Recursive User-Defined Function (SQL Server 2000)