Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with a column call MostRecent, and I have two types of load:
if exist a row with MostRecent=1, I need this load
LOAD
t_bpid,
t_nama,
t_ccur,
ValidFrom,
ValidTill,
Checksum,
MostRecent
Resident DimOld
Where exists (Checksum2, Checksum) and t_bpid = $(vCustomerNumber) and MostRecent=1;
but, if not exist a row with MostRecent=1, i need just one row with MostRecent=0 and execute this load.
date(now()) as ValidFrom,
Timestamp#('31-12-2099 08:00:00','DD-MM-YYYY hh:mm:ss') as ValidTill,
1 as MostRecent
Where exists (Checksum2, Checksum) and t_bpid = $(vCustomerNumber) and MostRecent=0;
I cannot execute both at the same time