Expanding Hierarchies - SQL 2000

>Ideas, thoughts, links to examples where this has already been done? <<

Get a copy TREES & HIERARCHY IN SQL and look at the Nested Sets model
for BOM. It will be much easier than what you are doing.i second that
its pretty simple and easy to implement. no recursion is a plus

On Dec 19, 12:21 am, --CELKO-- <jcelko...@.earthlink.netwrote:

Quote:

Originally Posted by

Quote:

Originally Posted by

Quote:

Originally Posted by

Ideas, thoughts, links to examples where this has already been done? <<

>
Get a copy TREES & HIERARCHY IN SQL and look at the Nested Sets model
for BOM. It will be much easier than what you are doing.