Update #Request.prefix_db_agency#.pSchedules SET Status = 1 WHERE Schedule_ID IN () Update #Request.prefix_db_agency#.pSchedules SET Emp_ID = 0 WHERE Schedule_ID IN ()