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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-05 : 08:00:53
|
| arif writes "suppose i have two tablesTableName:recruiter,recloginsrecruiter will have id as autoincrement for every main recruiter reclogins will have id as autoincrement and recid as id of recruiter table.In reclogin table consist of main recruiter id as well as sub recruiter id.both table will have status as fieldso my requirement is that i need to display in hierarcial mannerfor eg:mainrecruiterid status-------------------------1 1subrecruiterid status--------------------1 23 14 2mainrecruiterid status-------------------------2 1subrecruiterid status--------------------5 26 17 2" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
TREE STRUCTURE 