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 |
|
de4ever@gmail.com
Starting Member
36 Posts |
 Posted - 2010-07-28 : 02:31:49
|
| I Have a Content tableID DocumentNo Name IsRevised IsApproved1 D-001 Doc1 False False2 D-002 Doc2 False False3 D-003 Doc3 False False4 D-001 Doc1 True False5 D-002 Doc2 True False6 D-003 Doc3 True False7 D-001 Doc1 False True8 D-002 Doc2 False True9 D-003 Doc3 False Trueand a PubTable with ID DocumentID NameI want to display this data in heirarchy using id,parentidso that can be represented as DocumentName--> General PubName Revised PubName Approved PubNamePlease help me out |
|
|
de4ever@gmail.com
Starting Member
36 Posts |
Posted - 2010-07-28 : 02:34:02
|
| Hierarchy is DocumentName--> General -->PubName Revised -->PubName Approved -->PubNameDocumentName--> General -->PubName Revised -->PubName Approved -->PubName |
 |
|
|
|
|
|
Creating Heirarchy within same table