Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Joe Celko's Frammis example - Nested set models

Author  Topic 

mnorton
Starting Member

7 Posts

Posted - 2001-05-30 : 11:57:21
I've recently been trying to figure out how to do a parts breakdown into subassemblies. The example that I am trying to emulate for my own application is Joe Celko's frammis example that talks about Nested set models. I understand the concept behind his model but what I don't understand is the rgt and lft column and how he comes up with the numbers that he does for each part. If someone could explain this to me I would greatly appreciate it. Thanks for any help you can provide.
   

- Advertisement -