Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning, I have this script to load a table:
load
* from \Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd);
It works correctly but I would need to get the resulting table oredered by a field called 'FECHA' and I'm not able to write the right sintaxis.
Can anyboy help me please?
Thanks
HI,
You have to resident load your actual-table.
The load you have now is fine (perhaps name the tabel "<tabelname>_TMP", or so), but then afterwards, you do a resident load on your "_tmp" table. Here you are able to order by which field you like.
I hope it helps
/Martin
As Martin Says.
First:
TablaTemp:
load
* from \Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd);
Then:
TablaFinalOrdenada:
load
*
resident TablaTemp Order By Fecha Asc;
Asc is ascending, desc would be newest first. And Drop Table Tabla Temp;
add a noconcatenate to Roberto answer
TablaTemp:
load
*
from
\Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd);
TablaFinalOrdenada:
noconcatenate load
*
resident TablaTemp Order By FECHA;
Drop Table Tabla Temp;
Yes. Sorry Thanks Massimo. I had forgotten.