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 |
linka
Starting Member
3 Posts |
Posted - 2004-03-25 : 02:59:39
|
I have this table:ID(child) parent level attributeChild 1 ...................1.......1Child 2 ......Child 1 ...2.......1Child 3 ......Child 2....3.......2Then attribute=2 I have this info in next table:ID(child) Info_1 Info_2 Info_3Child3..........111.....222.....333In the result I must have this table :level 1...level 2... level 3...level 4...Info...fromChild 1....Child 2.... Child 3....null.....111... Info_1Child 1....Child 2.... Child 3....null.....222... Info_2Child 1....Child 2.... Child 3....null.....333... Info_3 Please, help me. |
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
linka
Starting Member
3 Posts |
Posted - 2004-03-25 : 06:55:25
|
I try this method,but can't get info from columns: Info 1, info 2 info 3.i must get not 111,222,333 in one rows, but must get 111,222,333 in different rows. |
|
|
|
|
|