Hi Thom,
Thanks for the post . But the condtion
E.MgrID = H.EmpID
will not work for Node C as its Parent Node is B which is not in H table
BR
Arshad
I don't understand what you're talking about. Thom's code works as expected and I'm sure that he tested it before posting.
What do you mean when you state that the condition will not work?
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2