update staff set type2='A001' where code='700006'
update staff set type2='A002' where code='000044'
update staff set type2='A014' where code='000023'
update staff set type2='A035' where code='700021'
update staff set type2='A036' where code='700022'
update staff set type2='A040' where code='000024'
update staff set type2='A043' where code='000005'
update staff set type2='A050' where code='710001'
update staff set type2='A051' where code='700013'
update staff set type2='A053' where code='710004'
update staff set type2='A071' where code='000084'
update staff set type2='A074' where code='700025'
update staff set type2='A090' where code='700030'
update staff set type2='A116' where code='700039'
update staff set type2='A119' where code='200053'
update staff set type2='A123' where code='200024'
update staff set type2='A124' where code='700040'
update staff set type2='A138' where code='000095'
update staff set type2='A139' where code='200035'
update staff set type2='A139' where code='710044'
update staff set type2='A148' where code='200038'
update staff set type2='A153' where code='710008'
update staff set type2='A159' where code='200058'
update staff set type2='A165' where code='700048'
update staff set type2='A170' where code='700049'
update staff set type2='A174' where code='200074'
update staff set type2='A175' where code='710016'
update staff set type2='A176' where code='200075'
update staff set type2='A179' where code='710017'
update staff set type2='A180' where code='200092'
update staff set type2='A183' where code='200084'
update staff set type2='A189' where code='200091'
update staff set type2='A192' where code='700015'
update staff set type2='A193' where code='000100'
update staff set type2='A194' where code='000033'
update staff set type2='A197' where code='710012'
update staff set type2='A198' where code='200097'
update staff set type2='A199' where code='710013'
update staff set type2='A203' where code='700008'
update staff set type2='A204' where code='700026'
update staff set type2='A205' where code='700032'
update staff set type2='A206' where code='700033'
update staff set type2='A208' where code='200007'
update staff set type2='A209' where code='200042'
update staff set type2='A210' where code='200018'
update staff set type2='A211' where code='710045'
update staff set type2='A213' where code='200016'
update staff set type2='A214' where code='710038'
update staff set type2='A215' where code='200012'
update staff set type2='A215' where code='710039'
update staff set type2='A217' where code='200009'
update staff set type2='A217' where code='710040'
update staff set type2='A218' where code='710006'
update staff set type2='A219' where code='710007'
update staff set type2='A220' where code='710010'
update staff set type2='A221' where code='200045'
update staff set type2='A222' where code='700051'
update staff set type2='A226' where code='200115'
update staff set type2='A227' where code='710015'
update staff set type2='A232' where code='200029'
update staff set type2='A236' where code='200121'
update staff set type2='A237' where code='200120'
update staff set type2='A238' where code='700054'
update staff set type2='A242' where code='700055'
update staff set type2='A244' where code='710022'
update staff set type2='A245' where code='000085'
update staff set type2='A246' where code='710023'
update staff set type2='A247' where code='700056'
update staff set type2='A248' where code='200136'
update staff set type2='A249' where code='200147'
update staff set type2='A251' where code='200152'
update staff set type2='A254' where code='200149'
update staff set type2='A256' where code='200146'
update staff set type2='A257' where code='710019'
update staff set type2='A260' where code='200150'
update staff set type2='A261' where code='700057'
update staff set type2='A264' where code='700058'
update staff set type2='A265' where code='700059'
update staff set type2='A266' where code='710014'
update staff set type2='A267' where code='200148'
update staff set type2='A268' where code='700060'
update staff set type2='A270' where code='700061'
update staff set type2='A272' where code='710020'
update staff set type2='A275' where code='700063'
update staff set type2='A277' where code='200155'
update staff set type2='A278' where code='200154'
update staff set type2='A280' where code='000087'
update staff set type2='A281' where code='700065'
update staff set type2='A282' where code='000089'
update staff set type2='A283' where code='000090'
update staff set type2='A284' where code='000088'
update staff set type2='A288' where code='200159'
update staff set type2='A289' where code='700067'
update staff set type2='A290' where code='710021'
update staff set type2='A291' where code='000092'
update staff set type2='A292' where code='200160'
update staff set type2='A293' where code='000093'
update staff set type2='A294' where code='200161'
update staff set type2='A295' where code='200164'
update staff set type2='A296' where code='710025'
update staff set type2='A297' where code='200169'
update staff set type2='A302' where code='710028'
update staff set type2='A303' where code='710029'
update staff set type2='A304' where code='710027'
update staff set type2='A305' where code='710026'
update staff set type2='A306' where code='200173'
update staff set type2='A308' where code='200175'
update staff set type2='A309' where code='000097'
update staff set type2='A310' where code='000094'
update staff set type2='A311' where code='200178'
update staff set type2='A312' where code='000099'
update staff set type2='A313' where code='200181'
update staff set type2='A314' where code='200182'
update staff set type2='A315' where code='200185'
update staff set type2='A316' where code='200187'
update staff set type2='A317' where code='700069'
update staff set type2='A318' where code='700070'
update staff set type2='A319' where code='700072'
update staff set type2='A320' where code='700073'
update staff set type2='A321' where code='700074'
update staff set type2='A322' where code='700075'
update staff set type2='A323' where code='700076'
update staff set type2='A324' where code='200191'
update staff set type2='M018' where code='700018'
update staff set type2='M039' where code='700038'
update staff set type2='M042' where code='700003'
update staff set type2='M044' where code='700042'
update staff set type2='M046' where code='700043'
update staff set type2='M049' where code='700047'
update staff set type2='M051' where code='700052'
update staff set type2='M053' where code='710009'
update staff set type2='M054' where code='700077'
update staff set type2='M056' where code='700064'
update staff set type2='M057' where code='700066'
update staff set type2='M058' where code='700068'
update staff set type2='M059' where code='700010'
update staff set type2='M060' where code='700019'
update staff set type2='M062' where code='700071'
update staff set type2='MC006' where code='700011'
update staff set type2='MC008' where code='700014'
update staff set type2='MC011' where code='700016'
update staff set type2='MC016' where code='000001'
update staff set type2='MC021' where code='000002'
update staff set type2='MC028' where code='000003'
update staff set type2='MC039' where code='700027'
update staff set type2='MC040' where code='700028'
update staff set type2='MC050' where code='700029'
update staff set type2='MC051' where code='700031'
update staff set type2='MC052' where code='000098'
update staff set type2='MC064' where code='700007'
update staff set type2='MC066' where code='700009'
update staff set type2='MC068' where code='700012'
update staff set type2='MC069' where code='710003'
update staff set type2='MC071' where code='710005'
update staff set type2='MC073' where code='700034'
update staff set type2='MC075' where code='000040'
update staff set type2='MC077' where code='700037'
update staff set type2='MC096' where code='000059'
update staff set type2='MCO19' where code='000078'
update staff set type2='MY001' where code='710031'
update staff set type2='MY006' where code='710033'
update staff set type2='MY012' where code='500004'
update staff set type2='MY015' where code='710032'
update staff set type2='MY016' where code='500003'
update staff set type2='MY020' where code='500001'
update staff set type2='MY023' where code='710034'
update staff set type2='MY024' where code='710035'
update staff set type2='MY025' where code='500005'
update staff set type2='PC001' where code='200017'
update staff set type2='PC007' where code='200066'
update staff set type2='PC012' where code='200026'
update staff set type2='PC013' where code='200036'
update staff set type2='PC014' where code='200051'
update staff set type2='PC015' where code='200189'
update staff set type2='PC018' where code='200105'
update staff set type2='PC019' where code='200124'
update staff set type2='PC022' where code='200129'
update staff set type2='PC023' where code='200132'
update staff set type2='PC027' where code='200004'
update staff set type2='PC028' where code='200142'
update staff set type2='PC029' where code='200158'
update staff set type2='PC032' where code='200162'
update staff set type2='PC033' where code='200163'
update staff set type2='PC034' where code='200165'
update staff set type2='PC035' where code='200034'
update staff set type2='PC036' where code='200168'
update staff set type2='PC037' where code='200170'
update staff set type2='PC040' where code='200176'
update staff set type2='PC041' where code='200177'
update staff set type2='PC042' where code='200179'
update staff set type2='PC044' where code='200183'
update staff set type2='PC045' where code='200184'
update staff set type2='PC046' where code='710002'
update staff set type2='PC047' where code='200186'
update staff set type2='PC048' where code='200188'
update staff set type2='PC049' where code='200190'
update staff set type2='PC050' where code='200131'
update staff set type2='VB021' where code='700020'
update staff set type2='VB024' where code='200027'
update staff set type2='VB026' where code='700023'
update staff set type2='VB027' where code='700024'
update staff set type2='VB034' where code='000030'
update staff set type2='VB060' where code='200023'
update staff set type2='VB062' where code='200028'
update staff set type2='VB077' where code='700035'
update staff set type2='VB079' where code='700036'
update staff set type2='VB090' where code='700041'
update staff set type2='VB095' where code='000096'
update staff set type2='VB096' where code='000058'
update staff set type2='VB098' where code='700045'
update staff set type2='VB101' where code='700046'
update staff set type2='VB104' where code='000067'
update staff set type2='VB111' where code='200052'
update staff set type2='VB116' where code='000073'
update staff set type2='VB120' where code='700050'
update staff set type2='VB123' where code='710011'
update staff set type2='VB126' where code='000077'
update staff set type2='VB135' where code='200077'
update staff set type2='VB137' where code='200088'
update staff set type2='VB138' where code='200089'
update staff set type2='VB140' where code='710030'
update staff set type2='VB142' where code='000083'
update staff set type2='VB144' where code='200099'
update staff set type2='VB146' where code='200102'
update staff set type2='VB147' where code='200103'
update staff set type2='VB152' where code='200110'
update staff set type2='VB153' where code='200109'
update staff set type2='VB158' where code='200118'
update staff set type2='VB159' where code='200117'
update staff set type2='VB163' where code='700053'
update staff set type2='VB173' where code='710024'
update staff set type2='VB180' where code='000013'
fefe