SQL Server Forums
Profile | Register | 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.12 seconds. Powered By: Snitz Forums 2000