Thnaks All. I was able to reach a suitable solution using the CASE WHEN EXISTS syntax!

John Rowan (10/27/2010)

---

Thanks Gus, your correct.

Chrissy321, You mentioned that you can't put the flag at the parent level because application/security reasons. Rarely have I seen where outside factors like...

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...