Hello everybody,
I've a little problem, I load a table from a data base like this:
fim_PIANO_DI_PRODUZIONE:
SQL SELECT *
FROM fim.dbo."PIANO_DI_PRODUZIONE"
order by ID_COMMESSA,DATA_ULT_RIC;
STORE fim_PIANO_DI_PRODUZIONE
No problem it's work but it's a big table so i want to load only the lines where the creation date are higher than the last execution!
So I do :
Let ThisExecTime = ReloadTime();
PIANO_DI_PRODUZIONE:
SQL SELECT *
FROM fim.dbo."PIANO_DI_PRODUZIONE"
WHERE DATA_ULT_RIC >= '$(ThisExecTime)';
But it doesn't work, no lines loading. I think it's a problem of data beetween ReloadTime and DATA_ULT_RIC.
DATA_ULT_RIC is in numeric like '38085,802407407' and the reloadtime '09/04/2013 05:45:12'.
How can I match this two date?
Thanks a lot for your Ideas/Answers!
Quentin