SELECT e.Employee_ID,a.AgencyType,e.skill,b.eaType,b.eaSchedule,b.eaClientEdit,b.eaNoteEdit from #Request.prefix_db_lookup#.Employee as e Inner join #Request.prefix_db_agency#.employee_auth as b on e.Employee_ID=b.eaID Inner join #Request.prefix_db_lookup#.Agency as a ON e.Agency_ID=a.Agency_ID where e.Level is null limit 0,1000 Update #Request.prefix_db_lookup#.Employee set Employee.Level='#TmpLevel#' where Employee_ID=#Eid#