|
Posted by Tony Rogerson on 10/07/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.
>
Navigation:
[Reply to this message]
|