An article in October's MSDN Magazine outlines the rules of recursion. Create the query that returns the top level (this is the anchor member). Write a recursive query (this is the recursive member).

There is no simple way to create recursive queries that have several levels of data (hierarchical data) in SQL Server 2000. A recursive query is used when you have a parent and child data stored ...

TSQL - Recursive query to generate self join combos up to 8 lvls deep Maxer Jun 18, 2009 Jump to latest Follow Reply ...