Processing occurs one at a time and calls a SQL Server stored procedure. The SPROC is recursive. For each ID that is submitted, it can have any number of child ID's.

In this article, we study some new characterizations of primitive recursive functions based on restricted forms of primitive recursion, improving the pioneering work of R. M. Robinson and M. D.

ANSI SQL 99 adds a recursive query capability which permits it.<BR><BR>SQL Server 2005 will add recursive query capability to T-SQL, but for no good reason doesn't use the ANSI syntax.