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 |
|
IBoonZ
Yak Posting Veteran
53 Posts |
 Posted - 2009-03-24 : 07:03:38
|
| HiI got following dataContractID // Contractpos //ParentID 3333 // 1 // 03333 // 2 // 03333 // 3 // 23333 // 4 // 23333 // 5 // 0If ParentID is null then its a positon, so i need a new collumn table, if ParentID is like here '2' then its a SUBposition of my contractposition 2.So is it possible to get something like this :ContractID // Contractpos //Contractsubpos 3333 // 1 // 03333 // 2 // 33333 // 2 // 43333 // 5 // 0If you have a better solution, greatly appriciated.I want to create a hierarchyThanks |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
|
|
|
|
|
Hierarchy