Generating HierarchyID

I would like to insert the hierarchyId like this

/ - CEO (Root)

/1/ - Purchase Manager /2/ - Sales Manager

/1/1/ - Purchase Executive /2/1/ - Sales Executive

This is what the hierarchy i would like to use, is it right one, if so how can i do this, can any one give me some code snippet.

8
задан Jeff Ogata 15 September 2011 в 02:32
поделиться