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 ...

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 ...

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 ...