Update Employee ID
--update employee information
update (
select *
from
---------------------------
---- USE employee_id ------
degree_data
--employee_prefs
--employee_profile
--employee_times
--finalized
--ot_req
--ier_certifications
--ier_community
--ier_courses
--ier_degree
--ier_honors
--ier_inservice
--ier_life_certs
--ier_organizations
--ier_presentations
--ier_teams
--user_access_log /*MAY TAKE A WHILE TO RUN*/
---------------------------
------ USE empl_id --------
--eval_empl_pr
--eval_pg01
--eval_pg02
--eval_pg03
--eval_pg04
--eval_pg05
--eval_pg06
--eval_pg07
--eval_pg08
--eval_pg09
--eval_pg10
--eval_pg12
--eval_pg13
--flt_empl
where employee_id = '123456'
--empl_id = '987654'
) set
employee_id = '123456';
--empl_id = '987654';