Subject | temporal table for stored procedure |
---|---|
Author | Alejandro Garcia |
Post date | 2007-04-06T14:02:40Z |
Hi! Is it possible in IB 7.5 to work in a stored procedure with a temporal table created using a SELECT? I need something like this:
SELECT Col1, Col2, Col3 FROM TABLE1 Where Contition1 AND Condtion2 AND ConditionN
ORDER BY Col1, Col3
AS TEMP
In the procedure I need the table to be in that order and I can't work with the original table TABLE1 because I need to preprocess it.
---------------------------------
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com
[Non-text portions of this message have been removed]
SELECT Col1, Col2, Col3 FROM TABLE1 Where Contition1 AND Condtion2 AND ConditionN
ORDER BY Col1, Col3
AS TEMP
In the procedure I need the table to be in that order and I can't work with the original table TABLE1 because I need to preprocess it.
---------------------------------
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com
[Non-text portions of this message have been removed]