You're prolly in luck -- I'm not reading your question/scenario very closely, but Oracle has really good syntax specifically for recursion.

(FYI: SQL Server is somewhat less good, but better in 2005 than it used to be.)

If memory serves, you want to check out the STARTS WITH and CONNECT BY clauses.

>L<