Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 What can I do?
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

linka
Starting Member

3 Posts

Posted - 03/25/2004 :  02:59:39  Show Profile
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!

Australia
4970 Posts

Posted - 03/25/2004 :  04:18:37  Show Profile  Visit Merkin's Homepage
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
Go to Top of Page

linka
Starting Member

3 Posts

Posted - 03/25/2004 :  06:55:25  Show Profile
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000