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
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Query to display father item,sub item...		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tony_cambodia
Starting Member

Cambodia
1 Posts
Posted - 08/28/2012 :  01:51:16  Show Profile  Reply with Quote
Hi all experts,
I have 3 father item and each father item has alot of sub items.
ex:Items "A,B,C" are Father Item.
A
A1
A1.1
A1.1.1
A1.1.2
A1.1.3
A1.2
A1.2.1
A1.2.2
A2
A3
A4
B
B1
B1.1
B1.1.1
B1.1.2
B1.1.3
B1.1.3.1
B1.1.3.2
B1.2
B1.2.1
B2
B2.1
B2.2
........
What query should i got the result like this?
Note:
the sub item can be the father item

Thanks
TONY

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3328 Posts
Posted - 08/28/2012 :  04:29:05  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
What does your data look like?
I'm guessing you have links in a hierarchy - is it a single table or a conjoint table?

Are you really v2000 - it makes a lot of difference to the solution.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Edited by - nigelrivett on 08/28/2012 04:29:51
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000