To do multible compids, use the following script:
php /var/www/html_j3sg/institutions/ChangeCompidOfAllInstitutionalAfewCompaniesAtATime.php
Please note that the script mentioned above (ChangeCompidOfAllInstitutionalAfewCompaniesAtATime) only updates the current13FFilingpositions table, no archived tables.
This script actual updates 13F current table as well as both archive13F tables.
We got coming in compid: : 131586
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '131586'
The Shares Amount is 66970000
The cusip is 670008101
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '670008101'
Number of Rows :223
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.99'
where entryId = '1141505'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '4.74'
where entryId = '1224337'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '9.25'
where entryId = '1265140'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.01'
where entryId = '1827903'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.06'
where entryId = '2832687'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.35'
where entryId = '2883192'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '238.17'
where entryId = '3031656'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '3167954'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '11.53'
where entryId = '3506274'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '32.06'
where entryId = '3732008'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.31'
where entryId = '3917395'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.4'
where entryId = '4113236'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.6'
where entryId = '4129447'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '44.35'
where entryId = '4374346'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '5.85'
where entryId = '5264829'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '4.77'
where entryId = '6910771'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '7614503'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.04'
where entryId = '7793321'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '6.78'
where entryId = '9342014'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '5.03'
where entryId = '9756258'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1002.67'
where entryId = '10244190'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '31.53'
where entryId = '10453627'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '10523257'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '10756382'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '11038544'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.99'
where entryId = '11054323'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '5.53'
where entryId = '11066062'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.69'
where entryId = '11077373'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '37.01'
where entryId = '11103426'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '11115837'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '146.36'
where entryId = '11181030'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '20.58'
where entryId = '11265961'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '11274285'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '363'
where entryId = '11449910'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '19.62'
where entryId = '11464555'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '11980932'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '3.34'
where entryId = '12075589'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '12116308'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '12179024'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.19'
where entryId = '12188232'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '592.38'
where entryId = '12230876'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '11.73'
where entryId = '12288153'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.5'
where entryId = '12319734'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '12326808'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '262.03'
where entryId = '12389708'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '12424271'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '215.35'
where entryId = '12574598'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.08'
where entryId = '12581954'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.79'
where entryId = '12779149'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '12790901'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.87'
where entryId = '12809560'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '20.49'
where entryId = '12846997'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '17.85'
where entryId = '12934700'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.1'
where entryId = '12987267'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '19.56'
where entryId = '12992440'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.04'
where entryId = '13024381'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '13456111'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.02'
where entryId = '13468105'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '13505335'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '13645329'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '13678120'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.17'
where entryId = '13681639'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '4.11'
where entryId = '13684414'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.1'
where entryId = '13684726'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.5'
where entryId = '13938989'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '14019551'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '18.86'
where entryId = '14074580'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.91'
where entryId = '14140395'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '273.31'
where entryId = '14216414'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '20.36'
where entryId = '14231853'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '14297435'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '50.55'
where entryId = '14327978'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '4.08'
where entryId = '14389305'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '14455367'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '14552877'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '14575674'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.04'
where entryId = '14584099'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '5.43'
where entryId = '14648989'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.01'
where entryId = '14661611'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.04'
where entryId = '14679494'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '19.26'
where entryId = '14876658'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '14944340'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '27.45'
where entryId = '14952088'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.18'
where entryId = '15098910'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '4.11'
where entryId = '15162252'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.1'
where entryId = '15162560'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '15175003'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.2'
where entryId = '15259360'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '15261891'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '41.43'
where entryId = '15302955'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.17'
where entryId = '15333468'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '15337164'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '23.23'
where entryId = '15341321'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.53'
where entryId = '15450259'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '5.43'
where entryId = '15468233'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.64'
where entryId = '15473723'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '4.05'
where entryId = '15632526'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '15.61'
where entryId = '15775280'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '15778638'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '272.21'
where entryId = '15973628'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '15983600'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.45'
where entryId = '16117809'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.04'
where entryId = '16195845'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '101.54'
where entryId = '16362603'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '16521406'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.92'
where entryId = '16582486'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.1'
where entryId = '16610917'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '16615251'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '4.11'
where entryId = '16618668'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.1'
where entryId = '16618996'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '16633604'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '16651071'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '6.44'
where entryId = '16675939'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.73'
where entryId = '16682494'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.73'
where entryId = '16682831'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.73'
where entryId = '16683146'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.73'
where entryId = '16683469'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.84'
where entryId = '16703747'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '34.25'
where entryId = '16729483'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.15'
where entryId = '16764357'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.5'
where entryId = '16835483'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.27'
where entryId = '16866171'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '3.64'
where entryId = '16908686'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '16920302'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.33'
where entryId = '16939017'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '262.19'
where entryId = '17011819'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '17013139'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.34'
where entryId = '17015929'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '17074788'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.54'
where entryId = '17145059'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '10.56'
where entryId = '17203377'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.45'
where entryId = '17541082'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.02'
where entryId = '17558009'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '17786723'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.04'
where entryId = '17979484'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.66'
where entryId = '17989802'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '18041687'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.24'
where entryId = '18048642'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '18058001'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '4.11'
where entryId = '18076405'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.1'
where entryId = '18076780'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '18091571'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.92'
where entryId = '18116401'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.15'
where entryId = '18182300'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '3.28'
where entryId = '18258744'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '18274105'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '144.07'
where entryId = '18276509'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '18293914'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.48'
where entryId = '18298599'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.12'
where entryId = '18356016'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '263.46'
where entryId = '18374015'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '32.96'
where entryId = '18383671'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '18551607'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.02'
where entryId = '18569706'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.54'
where entryId = '18572885'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '18711511'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '7.12'
where entryId = '18761588'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '14.77'
where entryId = '18806159'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.53'
where entryId = '18854029'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.36'
where entryId = '19054259'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.38'
where entryId = '19116026'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.56'
where entryId = '19149237'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '6.82'
where entryId = '19494881'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '19555646'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '16.32'
where entryId = '19556273'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '19592610'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '8.5'
where entryId = '19778681'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.37'
where entryId = '19884718'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.54'
where entryId = '19902535'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '30.27'
where entryId = '19976834'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '14.83'
where entryId = '19987607'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '14.83'
where entryId = '19987713'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '14.83'
where entryId = '19987961'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '14.83'
where entryId = '20128455'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '11.84'
where entryId = '20128579'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '11.84'
where entryId = '20128694'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.56'
where entryId = '20168659'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '14.93'
where entryId = '20307206'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.66'
where entryId = '20390382'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.62'
where entryId = '21065004'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.84'
where entryId = '21065354'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '21182532'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '21552881'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '22500098'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.17'
where entryId = '22686512'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.51'
where entryId = '23159579'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '58.29'
where entryId = '23175057'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '23404754'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '19.34'
where entryId = '23474129'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.42'
where entryId = '24087027'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.07'
where entryId = '24138627'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '24521650'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.52'
where entryId = '24632761'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '24921504'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '24927283'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '67.19'
where entryId = '26091339'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '9.78'
where entryId = '26245531'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.28'
where entryId = '26773802'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '27406934'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '28138433'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '28643286'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.34'
where entryId = '28730997'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.98'
where entryId = '28749134'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0.03'
where entryId = '29137030'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '29960282'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '31253173'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '7.56'
where entryId = '31799857'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '39.31'
where entryId = '31890026'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.09'
where entryId = '32908321'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '8.3'
where entryId = '33231813'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '33670692'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '3.44'
where entryId = '33722016'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '33878572'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.21'
where entryId = '34045252'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '34255221'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '1.8'
where entryId = '34895376'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '35293901'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '35540499'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.74'
where entryId = '36185819'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '8.51'
where entryId = '36485886'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '2.99'
where entryId = '36507798'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '37316746'
update current13Fpositions set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106' ,
percentOut = '0'
where entryId = '130460388'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '670008101'
Number of Rows :22
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '77781690'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '79945901'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '81762063'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '83867366'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '86102944'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '87803975'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '90135345'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '92205350'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '94254428'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '96028981'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '98417878'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '100989910'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '103550355'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '105765165'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '109068829'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '111856101'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '114287594'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '116761584'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '119646715'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '122410779'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '124955576'
update archive13F set
compid = '131586',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000836106'
where entryId = '127816719'
End Function
The Script is complete, exiting....