Thanks Gila

Thank you all, especially Sean & GSquared, your answers really helped me solving my problem.

Thanks Again 🙂

Thank you very much Sean,

This is what i was asking for but, i couldn't explain my point. the only problem is that I want the Immediate Parent of the node...

here is the Structure of the Table

DescriptionNode(HierarchyID)StringPath

Manager0x /

Dev Manager0x58 ...

OKay, I have columns name "Description" Charactor type and "SiteMapNode" of HierarchyID type. what I do is that i want to insert a new node (Description) and and its...