SET vMonth=01;
SET vYYYYMM=201901;
SET vNEW=0; //READ OLD DATA: 0 // DOWNLOAD NEW MONTH DATA: 1
IB_Table:
LOAD Customer,
[Customer (Loc)] as Site,
[S/N],
Printer,
Country,
Comments,
[Price Conditions],
[Installation date],
if(isnull(StartDate)=0,StartDate,201501) as StartDate,
if(isnull(EndDate)=0,EndDate,$(vYear)&if($(vMonth)<10,0)&$(vMonth)) as EndDate,
SubCustomer
FROM
Aplica la funcion insull a la columna Stardate.
Si el resultado de la funcion es 0 (no es null) deja el valor.
si el resultado de la funcion es 1 (es null) escribe el valor "201501"
Si el resultado de la funcion es 0 (no es null) deja el valor.
si el resultado de la funcion es 1 (es null) escribe el valor "201501"
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.