May 8, 2002 at 12:55 pm
Hey all-
Just wondering if anyone has used (really used) a nested set as demostrated in Celko's example? I have been asked to do something similar and feel that adding and deleting data would be a nightmare using nested sets.
Anyone have any examples they would like to share (T-SQL, SP, etc.)?
Sorry if this is the wrong forum, but I did not know where else to put it.
Thanks,
doug
May 8, 2002 at 3:11 pm
Can you post the example as we have had a few threads here about Joe Celko and I am afraid I have never seen his examples.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 9, 2002 at 9:58 am
He is using nested sets for a Bill of Materials (BOM).
Here is a link to his access 2k BOM
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy