Arthur Fuller demonstrates how to use recursion in T-SQL. TechRepublic’s free SQL Server newsletter ... using one of the classic examples of recursion: the factorial calculation.

A stored procedure is a set of SQL statements that can perform ... and the body of the procedure or function. For example, here is a simple stored procedure that takes a customer ID as an input ...

references the lCategoryID primary key in the same table<BR>szCategoryName varchar(100)<BR><BR>So for example you could have something like this to desribe the relationship: Electronics ...