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: : 137534
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '137534'
The Shares Amount is 114298000
The cusip is 87264S106
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '87264S106'
Number of Rows :179
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.62'
where entryId = '1265580'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '171.86'
where entryId = '1570367'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '1828260'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.07'
where entryId = '2207917'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.11'
where entryId = '2833515'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '7.83'
where entryId = '3031812'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '3579078'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.75'
where entryId = '3734549'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '7595706'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.97'
where entryId = '9342444'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.77'
where entryId = '9757376'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '15.59'
where entryId = '10250208'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '5.37'
where entryId = '12170833'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '12328033'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '12562014'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '12790976'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.01'
where entryId = '12935075'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '13679640'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '13818680'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '3.69'
where entryId = '14328683'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.29'
where entryId = '14389356'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '9.97'
where entryId = '14878550'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '5.37'
where entryId = '14912533'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '15263423'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '14.83'
where entryId = '15474329'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '15983677'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.35'
where entryId = '16029547'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.16'
where entryId = '16362669'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '5.37'
where entryId = '16393406'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '16616833'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '18.83'
where entryId = '16730044'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '16955235'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '17013225'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '17075184'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '17105313'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.84'
where entryId = '17145125'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.96'
where entryId = '17206880'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '17547284'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.12'
where entryId = '17558262'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '17772119'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '17786386'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '17954040'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.13'
where entryId = '17980399'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '4.08'
where entryId = '18570345'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.84'
where entryId = '18572939'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '4.37'
where entryId = '19111999'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.84'
where entryId = '19902618'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '20967298'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '7.91'
where entryId = '23178611'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '24505452'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '24522772'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '6.47'
where entryId = '24593401'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '24921761'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '24927828'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.62'
where entryId = '26773900'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '28642092'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.47'
where entryId = '28749192'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '5.08'
where entryId = '29136753'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '29960406'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.1'
where entryId = '30018056'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '5.27'
where entryId = '30104276'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.38'
where entryId = '31176588'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '31253457'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.27'
where entryId = '31412845'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.18'
where entryId = '31759186'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '3.42'
where entryId = '31800354'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '3.33'
where entryId = '31891378'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '32575270'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '32587769'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.13'
where entryId = '32908757'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '37.17'
where entryId = '33104309'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '33175120'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '33178555'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.71'
where entryId = '33325028'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '33693620'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '33878884'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '34254465'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '3.53'
where entryId = '34540986'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '35981647'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '8.85'
where entryId = '36283459'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '37278390'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.23'
where entryId = '38324507'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '38478999'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '39512239'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.42'
where entryId = '40850384'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.36'
where entryId = '41652436'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.08'
where entryId = '42055047'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '15.82'
where entryId = '42065941'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.28'
where entryId = '42067470'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.71'
where entryId = '42078861'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.27'
where entryId = '42082789'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '52.12'
where entryId = '42085823'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '46.67'
where entryId = '42091045'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '6.39'
where entryId = '42093776'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.15'
where entryId = '42096191'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.79'
where entryId = '42099805'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '7.18'
where entryId = '42101520'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.74'
where entryId = '42104031'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.52'
where entryId = '42104712'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '16.41'
where entryId = '42107495'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '25.55'
where entryId = '42115931'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.81'
where entryId = '42117466'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '8.4'
where entryId = '42117977'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '43.75'
where entryId = '42121110'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.58'
where entryId = '42122245'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.32'
where entryId = '42123296'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.89'
where entryId = '42132590'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.27'
where entryId = '42136456'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.44'
where entryId = '42138718'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.41'
where entryId = '42140601'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '3.07'
where entryId = '42144213'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.02'
where entryId = '42148354'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.81'
where entryId = '42149967'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.46'
where entryId = '42153018'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '5.78'
where entryId = '42153995'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '49.2'
where entryId = '42155947'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.54'
where entryId = '42161547'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.85'
where entryId = '42163954'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.11'
where entryId = '42164866'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.02'
where entryId = '42167470'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '42169677'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.24'
where entryId = '42182147'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '76.55'
where entryId = '42186921'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.01'
where entryId = '42190583'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.1'
where entryId = '42192821'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '3.76'
where entryId = '42196105'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '42198457'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '8.57'
where entryId = '42199720'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '3.74'
where entryId = '42205402'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.08'
where entryId = '42207788'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.27'
where entryId = '42215361'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '99.55'
where entryId = '42215752'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.26'
where entryId = '42225952'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '42.67'
where entryId = '42229546'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '3.88'
where entryId = '42230865'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '5.15'
where entryId = '42234825'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.13'
where entryId = '42235068'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.52'
where entryId = '42246309'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '5.54'
where entryId = '42247241'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.21'
where entryId = '42250328'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.59'
where entryId = '42251935'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.06'
where entryId = '42253296'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '42264611'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '42267455'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '42457395'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '42461200'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '42462050'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '42467635'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '42467898'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '42468905'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.78'
where entryId = '42499236'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '4.28'
where entryId = '43979177'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.47'
where entryId = '44020600'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.09'
where entryId = '44309618'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '3.78'
where entryId = '45516217'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '56.55'
where entryId = '46033248'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '27.56'
where entryId = '46540078'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.75'
where entryId = '47281312'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '59.49'
where entryId = '48062448'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.12'
where entryId = '48478276'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '1.4'
where entryId = '49294718'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0.64'
where entryId = '49376429'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.19'
where entryId = '50089507'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.58'
where entryId = '50161068'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '50525029'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.99'
where entryId = '50672270'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '2.88'
where entryId = '50844474'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '24.23'
where entryId = '51217383'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '136.63'
where entryId = '51244870'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '3.53'
where entryId = '51524681'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '52243899'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '4.59'
where entryId = '53430336'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '14.6'
where entryId = '53469692'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '14.35'
where entryId = '53517911'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '53986147'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '54220368'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '3.84'
where entryId = '54379612'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '56832967'
update current13Fpositions set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097' ,
percentOut = '0'
where entryId = '61627245'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '87264S106'
Number of Rows :12
update archive13F set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097'
where entryId = '67780480'
update archive13F set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097'
where entryId = '47198445'
update archive13F set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097'
where entryId = '75872284'
update archive13F set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097'
where entryId = '75872323'
update archive13F set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097'
where entryId = '75872361'
update archive13F set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097'
where entryId = '75923659'
update archive13F set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097'
where entryId = '45289325'
update archive13F set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097'
where entryId = '90334657'
update archive13F set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097'
where entryId = '51038614'
update archive13F set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097'
where entryId = '43898280'
update archive13F set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097'
where entryId = '96634145'
update archive13F set
compid = '137534',
sectorNum = '101003',
sectorDes = 'Auto Parts',
issuerCik = '0001267097'
where entryId = '97563615'
End Function
The Script is complete, exiting....