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 - 2000-12-18 : 14:16:14
|
vivek writes "how to transfer given below table 1 data( contains tree structure data) to table 2 specified format: give query or statement or procedure with logic:
table 1
id name level_no parent_id
1 abc 0 0
2 def 1 0
3 ghi 2 2
4 jkl 2 2
5 mno 3 4
6 pqr 1 0
7 st 2 6
8 uv 3 7
9 wx 4 8
10 yz 3 7
11 ac 1 0
12 hk 2 11
.
.
.
.
I require table 1 data in a format given below :
table 2 format
level0 level1 level2 level3 level4
abc na na na na
abc def na na na
abc def ghi na na
abc def jki na na
abc def jki mno na
abc pqr na na na
abc pqr st na na
abc pqr st uv na
abc pqr st uv wx
abc pqr st yz na
abc ac na na na
abc ac hk na na
.
.
.
.
na= not available
please give complete sql statment or procedure through which I get table 2 data." |
|
|
|
|
|
table 2 data