Re: Need Help Spanning A Category Tree

Get a copy of TREES & HIERARCHIES IN SQL and about the Nested Sets
Model. It will run much better than this adjacency list model. You
are just mimicking pointer chains in SQL instead of doing declarative
set processing. The CTE kludge is a hidden cursor, etc.

.

Relevant Pages

  • Re: Self-join question
    ... I am not an advanced SQL user and it's hard ... > There are many ways to represent a tree or hierarchy in SQL. ... > called an adjacency list model and it looks like this: ... > Another way of representing trees is to show them as nested sets. ...
    (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)
  • Re: Employees Hierarchy
    ... > There are many ways to represent a tree or hierarchy in SQL. ... > called an adjacency list model and it looks like this: ... > Another way of representing trees is to show them as nested sets. ...
    (microsoft.public.sqlserver.programming)
  • Re: how to suppress carefully a recursive tree
    ... Get a copy of TREES & HIERARCHIES IN SQL and look up the Nested Sets ... You can Google it for the basic idea. ...
    (comp.databases.theory)
  • Re: SELECT & recursion
    ... Get a copy of TREES & HIERARCHIES IN SQL for single table, ... models that use only SQL-92. ... In particular look at the nested sets ...
    (comp.databases)
Loading