-- pharmanet.sp_InsertAttendanceIn_HA (PROCEDURE)
begin
	INSERT INTO attendance_HA(UserID, AttendanceInTime, AttendanceInLocationID)
	VALUES(userID1, NOW(), locationID);
end