Posted by --CELKO-- on 11/28/49 11:58

You might want to get a copy of TREES & HIERARCHIES IN SQL for several
other approaches to this kind of problem. In particular, look up the
nested sets model which can quickly give you all the subordinates of
any node in one query, no matter how deep the tree goes.

• Next in forum: Re: Line Break in T-SQL
• Prev in forum: Download the JAVA , .NET and SQL Server interview PDF
• Thread view: Re: How to display the managers and the employees working under that Manager

[Reply to this message]