Posted by Tony Rogerson on 12/05/59 11:31

The nested set method you will see is:-

1) Difficult to maintain
2) Does not scale nor perform well out of the lab and in the real
world.

A better method is that developed by Itzik Ben Gan, information here:
http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=8826&DisplayTab=Article

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"--CELKO--" <jcelko212@earthlink.net> wrote in message
news:1131507918.597319.18700@f14g2000cwb.googlegroups.com...
> Get a copy of TREES & HIERARCHIES IN SQL and learn how to do it one
> simple query.
>

[Back to original message]