-- pharmanet.sp_UpdateAttendanceOut_HA (PROCEDURE)
begin
	UPDATE 
		attendance_HA
	SET 	
		AttendanceOutTime = NOW(),
		AttendanceOutLocationID = locationID
	WHERE 
		AttendanceID = attendanceID1;
end