|
|
Posted by Tony Rogerson on 10/07/12 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
"ven" <venome_@poczta.onet.pl> wrote in message
news:dkkuca$grf$1@news.onet.pl...
> hello i have a table with four fields : name_id, name, tree_id, level with
> these data:
>
> 1 name1 001 1
> 2 name2 002 1
> 3 name3 003 1
> 4 name4 001001 2
> 5 name5 001002 2
> 6 name6 001003 2
> 7 name7 001001001 3
>
> tree:
>
> 1-
> - 4
> -7
> -5
> -6
> 2-
> 3-
>
> and procedure which add nodes to tree looks
> tree.add(idparent,idchild,name)
>
> how to write select which returns idparent,idchild and name then i can add
> nodes in loop reading datareader ?
>
Navigation:
[Reply to this message]
|