Please start any new threads on our new site at 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 

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 -