GSquared (10/27/2010)

Your solution will work if the hierarchy only has two levels. To be precise, it will work if a child can't have...

I haven't looked at a hierarchy model. The child to parent ratio is fairly low, 5:1 on average.

I was thinking I could do an existence check in a subquery.

pseudo...

I tried this using linked server and had to terminate the query after 5 minutes. My table has 75 million rows.

I added WHERE clauses and then ran...

If to put the code populating table EmpChart nto a trigger on table Emp then every change in the Org Chart will be reflected immediately in EmpChart and ready for...

Thanks all. Yes I am still using 2000 (or at least my vendor is). This definitely is a bigger can of worms than I first thought!

I am going to try...