Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DotNetP
Starting Member
1 Post |
 Posted - 2009-06-22 : 11:57:45
|
| Hi all,I leverage HierarchyId data type to implement tree structure in a table.Scenario: We are working on a project management system. First of all, user must define the hierarchial structure of the persons contributing to that new project(i.e defining project manager and subordinate relatioships). Consequently, We are going to store the hierarchial structure of different projects in one table in order to manage them and each project has its own structure and root. These tree structures are independent of each other and projects are advancing in parallel.What's Your Solution? Is it a good idea to define a main root for all projects?Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-22 : 12:02:29
|
| http://msdn.microsoft.com/en-us/magazine/cc794278.aspx |
 |
|
|
|
|
|
HierarchyId And Multiple-Trees