Re: Single query to find multi-level relationships?

get a copy of TREES & HIERARCHIES IN SQL and look at the nested sets
model.
.

References:
- Single query to find multi-level relationships?
  - From: John Gordon

Relevant Pages

RE: SQL Procedure- Hierarchy listing of table content
... Trees in SQL: Nested Sets and Materialized Path ... Joe Celko's Trees and Hierarchies in SQL for Smarties ...
(microsoft.public.sqlserver.programming)
Re: how would I store the XML
... Trees and hierarchies in SQL are fairly complex when it comes to ... So, unless you are using SQL Server 2005, I recommend storing the Xml ... Trees in SQL: ...
(microsoft.public.dotnet.xml)
RE: SQL Procedure- Hierarchy listing of table content
... Manipulating Hierarchies with UDFs ... > Trees in SQL: ... > AMB ...
(microsoft.public.sqlserver.programming)
Re: Trying to implent (Joe Celkos) Nested Sets, but need more data columns
... Nested sets are just one of many ways to model such ... >things in SQL. ... If anyone using nonrelational features needs help, ... It's possible to model hierarchies to obtain all the benefits of your ...
(microsoft.public.sqlserver.programming)
Recursive queries?
... Joe Celko's Trees and hierarchies in SQL for smarties / ...
(microsoft.public.sqlserver.programming)