Delimiter //
/**
 * Set the default last update value.
 * 
 * @param int batchnum
 * @author Benoit
 */ 
Drop Procedure if Exists LOADER_CONTACTS_NORMALIZE_MAP_LAST_UPDATE_SET//
 
Create Procedure LOADER_CONTACTS_NORMALIZE_MAP_LAST_UPDATE_SET (
    In batchnum int
)
Begin

    Update 
        LOADER_CONTACTS C
        Inner Join LOADER_STATUS S
            On S.ID_LOADER_STATUS = C.LOADER_STATUS_ID_LOADER_STATUS
    Set 
        C.CONTACTS_LAST_UPDATE = Now()
    Where
        S.LOADER_STATUS_BATCH_NUM = batchnum
        -- And C.ID_CONTACTS_NEW Is Not Null -- Commented because both new and updated contacts need it
   ;

End //
Delimiter ;