Hi Dave Ballantyne,

You Asked Me...

Hi,

you seem to be missing some very important data here.

your xml shows that "Brenda Smith" is a child of "Alexander Tuckings", but why ?

What data specifies that relationship ?

But Actual Relationship is Position.

Alexander Tuckings Position is Team Lead Team1

Brenda Smith Position is Senior QA

so that means Brenda Smith was subordinator of Alexander Tuckings

It Seems like Management Heirarchy ==> Top Level Management To Lower Level Management

you do one think please Refer my given Table that data Shows Actual Heirarchy Order so you Aditionaly Insert the Identity Column or Serial No ....

I Think I will be Very Usefull to u ... To Get Result...

Please Try it...

Thanks & Regards,

Saravanan.D