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: : 141092
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '141092'
The Shares Amount is 47515000
The cusip is 00439T206
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '00439T206'
Number of Rows :32
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '54.24'
where entryId = '30669526'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0'
where entryId = '33178549'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '115.75'
where entryId = '33337906'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '10.52'
where entryId = '33347600'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '549.11'
where entryId = '38565800'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0'
where entryId = '39099667'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '5.03'
where entryId = '41650319'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '2.88'
where entryId = '41673838'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '14.7'
where entryId = '42104830'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '870.66'
where entryId = '42136715'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '6.43'
where entryId = '42144965'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0.05'
where entryId = '42162059'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '81.06'
where entryId = '42169814'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '15.92'
where entryId = '42174418'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '495.94'
where entryId = '42215469'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '4.53'
where entryId = '42223684'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0'
where entryId = '42469372'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '10.86'
where entryId = '51207125'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '3.13'
where entryId = '52939842'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '69.46'
where entryId = '56363266'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0'
where entryId = '58392225'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '15.7'
where entryId = '59765268'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '91.28'
where entryId = '60344048'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0'
where entryId = '64105966'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '74.8'
where entryId = '64626697'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0'
where entryId = '64973542'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0'
where entryId = '65631533'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0'
where entryId = '65858111'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0'
where entryId = '65860203'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0'
where entryId = '65860355'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0'
where entryId = '65860465'
update current13Fpositions set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979' ,
percentOut = '0'
where entryId = '65860807'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '00439T206'
Number of Rows :153
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65239044'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66548067'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65860867'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65671087'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66583167'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66591368'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66550271'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65672476'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66573410'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66080570'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66549743'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66656468'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66558628'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66074241'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66584383'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65849468'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65848998'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66588942'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66581487'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66546862'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66080406'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66552943'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66578089'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66589113'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66589059'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65860002'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66584299'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66585064'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66654559'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65852209'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66577632'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66590742'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66589897'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65858668'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66079472'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65859425'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66656227'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65858247'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65632763'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66580500'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65850246'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65382756'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65667495'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65855227'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65665036'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66587542'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65855442'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66572023'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66551581'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66583552'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65856825'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65672662'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65230756'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65247087'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65860534'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65670833'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66067898'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65234536'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65665387'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66653079'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65377937'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '65231806'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66656517'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '66080662'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63377003'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63395719'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63421465'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63496527'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64130360'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64011809'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63718774'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64967531'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63674645'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64394431'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63754359'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64942509'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64761436'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63620992'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64935509'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63933591'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64223598'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64874927'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64008245'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63830862'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64013530'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64440091'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64866466'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64549244'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64197321'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64758587'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64413513'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64108244'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64318025'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63898946'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64085656'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64202040'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64172160'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63640127'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63937572'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64089361'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63961140'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63868706'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63914390'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64252049'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64440181'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64451607'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64940731'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64387749'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64116143'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64922012'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64939802'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64265741'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64233689'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63781956'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64529846'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64629421'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64430475'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64682353'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64529894'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64568351'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64971029'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64488387'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64554160'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64514339'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64947741'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64430516'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64516864'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64932804'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '63859982'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64503958'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64937369'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64457588'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64212822'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64571044'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64799104'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64347648'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64925167'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64466572'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64921097'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64920367'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64151614'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64357742'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64550267'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64807577'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64731815'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64648013'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64848016'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64852682'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64866786'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64899181'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '64834649'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '51036242'
update archive13F set
compid = '141092',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0000817979'
where entryId = '96631808'
End Function
The Script is complete, exiting....