What can I do? - SQL Server Forums

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

Old Forums

CLOSED - General SQL Server

What can I do?

Author

Topic

linka
Starting Member

3 Posts

Posted - 2004-03-25 : 02:59:39

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

Please, help me.

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-03-25 : 04:18:37

Hi linka

Have a read of this http://www.sqlteam.com/item.asp?ItemID=2955 and see if it answers any questions for you

Damian

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources