Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Self Joins...
Message
From
08/02/2000 09:36:29
 
 
To
07/02/2000 16:56:15
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00328133
Message ID:
00328748
Views:
22
>Thanks. Say, if I don't do it the way I was thinknig, how would the record oriented way work?

It would depend on whether the parent contained a pointer to the children or the other way around. A binary tree is usually implemented as the parent pointed to the children. Other trees usually have the children containing a pointer to the parent. So given a parent, it's easy to find all the children. Recursion works really well, depending on the expected depth of the tree.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform