Recursion is implemented in standard SQL-99 using common table expressions (CTEs). DB2, Microsoft SQL Server, Oracle and PostgreSQL all support recursive queries using CTEs. Note that Oracle also ...

Essentially they are submitting ID numbers. 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 ...