-- apps_master.sp_UpdateOperational (PROCEDURE) begin UPDATE apps_master.outlet_operational SET OutletType = typeOpr, OutletOprOpen = openOpr, OutletOprClose = closeOpr, ActiveYN = 'Y', LastUpdated = NOW(), UpdatedBy = idUser WHERE OutletOprDay= dayOpr AND OutletID = id; end