SELECT * FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID > 4414 UPDATE #Request.prefix_db_lookup#.pEmployee SET Username= '#empUsername#' WHERE Emp_ID = '#Emp_ID#' SELECT * FROM #Request.prefix_db_agency#.employee_auth WHERE eaID = '#Emp_ID#' INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaRole ) VALUES ( , )