Is recursion allowed in Stored Procedures in SQL Server ?

Yes.

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning