b1nary0mega
8/27/2015 - 4:57 PM

Update Employee ID

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';