want a ado datashape command

From: kalikoi@xxxxxxxxx
Date: 2 Feb 2006 00:47:27 -0800

I got four table structures as follows



CREATE TABLE [dbo].[Sector] (
	[SectorID] [int] NOT NULL ,
	[SectorName] [varchar] (50)
)

the data is as follows
----------------------
10	Energy





CREATE TABLE [dbo].[GroupMaster] (
	[SectorID] [int] NOT NULL ,
	[GroupID] [int] NOT NULL ,
	[GroupName] [varchar] (50)
)

the data is as follows
-----------------------
10   1010   Energy


CREATE TABLE [dbo].[IndustryMaster] (
	[GroupID] [int] NOT NULL ,
	[IndustryID] [numeric](6, 0) NOT NULL ,
	[IndustryName] [varchar] (50)
)


the data is as follows
-------------------------------------------
1010	101010	Energy Equipment & Services
1010	101020	Oil & Gas



CREATE TABLE [dbo].[SubIndustryMaster] (
	[IndustryID] [numeric](6, 0) NOT NULL ,
	[SubIndustryID] [numeric](8, 0) NOT NULL ,
	[SubIndustryName] [varchar] (30)
)

the data is as follows
-----------------------------------------------------
101010	10101010	Oil & Gas Drilling
101010	10101020	Oil & Gas Equipment & Svcs
101020	10102010	Integrated Oil & Gas
101020	10102020	Oil & Gas Exploration & Prod
101020	10102030	Oil & Gas Refining & Mktg
101020	10102040	Oil & Gas Storage & Transpor
101020	10102050	Coal & Consumable Fuels


Now i want a ADO DataShape command which results the following


Energy
	Energy
		Energy Equipment & Services
			Oil & Gas Drilling
			Oil & Gas Equipment & Svcs

		Oil & Gas
			Integrated Oil & Gas
			Oil & Gas Exploration & Prod
			Oil & Gas Refining & Mktg
			Oil & Gas Storage & Transpor
			Coal & Consumable Fuels

.

Prev by Date: UpdateBatch question
Next by Date: Re: Is MoveFirst() required before Seek() to perform seek-and-scan?
Previous by thread: UpdateBatch question
Next by thread: Re: Is MoveFirst() required before Seek() to perform seek-and-scan?
Index(es):
- Date
- Thread

Relevant Pages

Re: help
... [SectorID] ... Oil & Gas Equipment & Svcs ...
(comp.databases.ms-sqlserver)
HOLLYWIERD PICTURES SCREENPLAY: "How The War Began And Evolved"
... "How The War Began And Evolved" ... INT: 1973. ... Persian/Shia/Sunni competition in Iran is the cause of recent gas ... Iran's oil off the world market. ...
(soc.culture.iraq)
HOLLYWIERD PICTURES SCREENPLAY: "How The War Began And Evolved"
... "How The War Began And Evolved" ... INT: 1973. ... Persian/Shia/Sunni competition in Iran is the cause of recent gas ... Iran's oil off the world market. ...
(soc.veterans)
Chicago Tribune Special: A Tank Full of Gas, A World Full of Trouble
... A Tank Full of Gas, ... Howard Dunbar's Tanker Truck 6 rolled into the station one chilly night last ... oil patch. ... Elgin Marathon, the evidence is painfully obvious: ...
(alt.gathering.rainbow)
Dick Cheney: ". . . the Middle East . . . is the prize" -- and now you know why we invaded
... of course oftentimes people say that work in the oil industry is ... later on about gas, but obviously for over a hundred years we as an industry ... exploration risk but dealing with above ground political risk and commercial ...
(alt.politics)