Here's the deal: I have a database with table called Categories. Categories has a parent-child relationship in them. Here's what the table looks like (exluding stuff not related to the problem ...

DB2, Microsoft SQL Server, Oracle and PostgreSQL all support recursive queries using CTEs ... The MGR_ID for the top-most node is set to some value indicating that there is no parent for this row, in ...

Processing occurs one at a time and calls a SQL Server stored procedure. The SPROC is recursive ... believe it only goes down two levels...ie a Parent can have children, and the children can ...