-- apps_master.sp_UpdateOutlet1_HA (PROCEDURE) begin UPDATE apps_master.m_outlet1 set OutletPhone = phone, OutletEmail = email, OutletAddress = address, LastUpdated = NOW(), UpdatedBy = userID WHERE OutletID = id; end