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

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 of child ID's.

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