The problem : the table is a multi level data like this
Parent Id Name
------ -- -----------
0 1 World
1 2 Europe
1 3 North America
2 4 France
4 5 Paris
3 6 United States
3 7 Canada
6 8 New York
6 9 Washington
8 10 New York City
9 11 Redmond
Then, when I choose location under the [world] the display is:
World
North America
Canada
United States
Washington
Redmond
New York
New York City
Europe
France
Paris
when I choose location under [Utited states] the display is:
United States
Washington
Redmond
New York
New York City
This example was found in SQL-Server help
(Administrator companion's 6.0, Expanding Hierarchies)
so, I need the temporary table in SQL-Server to proccess the display,
and now I have to change the databse to Oracle
any one have idea
Best regards,
Dedy
----- Original Message -----
From: "Dennis Chuah" <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2001 10:02 AM
Subject: RE: [DUG]: Temporary table
> Wouldn't it be more efficient to
> select sum(aset.volume)
> from aset
> inner join location
> on location.id = aset.location
> where ...
>
> In Oracle, you will need to use the old join syntax:
> select sum(aset.volume)
> from aset, location
> where location.id = aset.location and ...
>
> Regards,
> Dennis.
>
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 9 April 2001 18:54
> Subject: [DUG]: Temporary table
>
> Hi,
>
> I use Delphi 5 and SQL Server, to increase speed of query some time I used
> temporary table, beacuse without temporary table the query was :
> select sum(volume) from aset where location in (select id from location
> where ...)
>
> using caluse IN, the index does not run (the speed is very low)
>
> Then, I changed then query :
> select sum(volume) from aset, #loc where location=id
>
> before the query, the temporary table (#loc) was created and fill with
> location to be prossess with the second way the speed increase
>
> Now I need to change the Database to Oracle ...
> Any one know how to create temporary table in Oracle like in SQl-Server ?
>
deleted ..
> Dedy
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
