Posted by --CELKO-- on 06/12/07 02:48

>> Is there a better way of storing the data, or is this the only way? <<

Get a copy of TREES & HIERARCHIES IN SQL for several different ways to
do an organizational chart. What you have is teh adjacency list
model; look up the nested sets model.

• Next in forum: Re: UPDATETEXT, WRITETEXT
• Prev in forum: Re: Establishing Precedence In ORDERBY Condition Causing Problems.
• Thread view: Re: Database Design Question

[Reply to this message]