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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  What can I do?

Author  Topic  linka Starting Member 3 Posts Posted - 2004-03-25 : 02:33:19 I have this table: ID(child) parent level attribute Child 1 ...................1.......1 Child 2 ......Child 1 ...2.......1 Child 3 ......Child 2....3.......2 Then attribute=2 I have this info in next table: ID(child) Info_1 Info_2 Info_3 Child3..........111.....222.....333 In the result I must have this table : level 1...level 2... level 3...level 4...Info...from Child 1....Child 2.... Child 3....null.....111... Info_1 Child 1....Child 2.... Child 3....null.....222... Info_2 Child 1....Child 2.... Child 3....null.....333... Info_3 What can I do? Please, help me.