Re: temporal table for stored procedure

Article View: borland.public.interbase.sql

Article #993

Back to borland.public.interbase.sql Previous Next

#993

From: aleplgr
Date: Sat, 07 Apr 2007 10:34

15 lines
1627 bytes

"Bill Todd" <no@no.com> wrote:
>aleplgr wrote:
>Yes. Create a Global Temporary Table as part of the database then
>INSERT into it in the stored procedure. See CREATE TABLE in the
>Language Reference.
>

But the stored procedure needs the table to be ordered in a particular order.
 So I CREATE the table, then INSERT from a SELECT to set the Condition1,... ConditionN and then I need some way to ORDER it and work with it in the procedure with the table ordered. I can't INSERT in ORDER.
 I need something like 
SELECT * FROM TEMP1 ORDERED BY COL1  AS TEMP
because my procedure needs the table ordered 

 I should order the table before starting to work with it in the procedure and I don't know how to ORDER it and give it a name..

Technical Details

Message-ID: <461765aa$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!212.101.4.254.MISMATCH!solnet.ch!solnet.ch!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <461651ac$1@newsgroups.borland.com> <46165aee$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,ea63e4de71f1ac2a
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "aleplgr" <aleplgr@yahoo.es>
Sender: "aleplgr" <aleplgr@yahoo.es>
Reply-To: "aleplgr" <aleplgr@yahoo.es>
Subject: Re: temporal table for stored procedure
Newsgroups: borland.public.interbase.sql
X-User-Info: 80.58.205.38     
X-Forwarded-For: 80.25.195.180, 192.168.1.66
References:  <461651ac$1@newsgroups.borland.com> <46165aee$1@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.66
Message-ID: <461765aa$1@newsgroups.borland.com>
Date: 7 Apr 2007 02:34:34 -0800
X-Trace: newsgroups.borland.com 1175938474 207.105.83.66 (7 Apr 2007 02:34:34 -0800)
Lines: 16
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!212.101.4.254.MISMATCH!solnet.ch!solnet.ch!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message