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: : 131003
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '131003'
The Shares Amount is 87237000
The cusip is 218868107
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '218868107'
Number of Rows :142
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '88.84'
where entryId = '1097436'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.85'
where entryId = '1264413'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.02'
where entryId = '1827321'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '25.2'
where entryId = '2420510'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '41.48'
where entryId = '3031381'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '2.06'
where entryId = '3504245'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '270.15'
where entryId = '3727870'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '4073714'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '804.11'
where entryId = '4374152'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '24.18'
where entryId = '5747354'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '4.44'
where entryId = '9679471'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '1.52'
where entryId = '9754144'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '65.82'
where entryId = '10232197'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '155.96'
where entryId = '11102881'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '11251009'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '3.09'
where entryId = '11449302'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.06'
where entryId = '11778235'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '2.61'
where entryId = '12286714'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '4.28'
where entryId = '12318371'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '12326164'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '12423802'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '12446449'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '192.59'
where entryId = '12447509'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '143.03'
where entryId = '13020802'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '11.79'
where entryId = '13242499'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.06'
where entryId = '13244623'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.42'
where entryId = '13467653'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '13677477'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '13817409'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '176.88'
where entryId = '13885469'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '893.18'
where entryId = '14098669'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '11.46'
where entryId = '14149224'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.06'
where entryId = '14193234'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '6.33'
where entryId = '14326864'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '5.81'
where entryId = '14389218'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '14552416'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '63.59'
where entryId = '14648924'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.48'
where entryId = '14661007'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '164.15'
where entryId = '14676637'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '14822694'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.07'
where entryId = '14873212'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '627.36'
where entryId = '15160249'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '15237526'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '15261248'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '15336712'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.3'
where entryId = '15449535'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '36.69'
where entryId = '15468091'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '9.48'
where entryId = '15627432'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.06'
where entryId = '15730312'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '2.57'
where entryId = '16028755'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.48'
where entryId = '16117207'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '107.04'
where entryId = '16192362'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '16614600'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '23.73'
where entryId = '16675810'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '10.05'
where entryId = '16762944'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.29'
where entryId = '16834769'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '385.88'
where entryId = '16885003'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '47.52'
where entryId = '16918714'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '16919851'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '16955649'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '2.21'
where entryId = '17014803'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '17074025'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '7.15'
where entryId = '17130369'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '88.51'
where entryId = '17191186'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '16.72'
where entryId = '17197168'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '2.78'
where entryId = '17274769'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '2.19'
where entryId = '17277918'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.48'
where entryId = '17540459'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '17787126'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '128.76'
where entryId = '17859074'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '8.24'
where entryId = '18180979'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '18273396'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '207.98'
where entryId = '18276432'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '18293475'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.29'
where entryId = '18297872'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '18355307'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '46.81'
where entryId = '18493912'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '18609593'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '86.09'
where entryId = '18695564'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '18823988'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.33'
where entryId = '19115415'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '26.03'
where entryId = '19615397'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '3.24'
where entryId = '19684675'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '3.24'
where entryId = '19697740'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '46.76'
where entryId = '19824244'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.04'
where entryId = '19880286'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '10.66'
where entryId = '20167858'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '2.81'
where entryId = '20390224'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.31'
where entryId = '20791062'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '22227649'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '13.91'
where entryId = '22369319'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '1.05'
where entryId = '22449114'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '4.14'
where entryId = '22686453'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '2.89'
where entryId = '23146153'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '19.08'
where entryId = '23169753'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.08'
where entryId = '24138192'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '24519908'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '24921653'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '24928538'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '28132697'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '28137778'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '28138060'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '28642257'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.45'
where entryId = '28779167'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '29312273'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '29344116'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '29684397'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '1.38'
where entryId = '29956887'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '29960633'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '1.33'
where entryId = '30518695'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '31290088'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '4.1'
where entryId = '31799046'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '6.74'
where entryId = '32907643'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '36763518'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '38299480'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '40896860'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '41123169'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '4.42'
where entryId = '41650839'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '2.7'
where entryId = '41674285'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '1.15'
where entryId = '42074400'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.45'
where entryId = '42078613'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '15.83'
where entryId = '42105491'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '55.02'
where entryId = '42108022'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '2.42'
where entryId = '42114499'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '6.14'
where entryId = '42145498'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '29.44'
where entryId = '42150905'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '21.64'
where entryId = '42157898'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '1.9'
where entryId = '42174608'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '39.55'
where entryId = '42175722'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '42202996'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '8.79'
where entryId = '42221981'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '2.48'
where entryId = '42224269'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '61.73'
where entryId = '42231772'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '42468987'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '42469776'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '3.71'
where entryId = '42497810'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '1.84'
where entryId = '44306594'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '118.28'
where entryId = '47143273'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0'
where entryId = '50510763'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '3.36'
where entryId = '51209542'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '0.01'
where entryId = '130458812'
update current13Fpositions set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134' ,
percentOut = '1.16'
where entryId = '130929767'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '218868107'
Number of Rows :57
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '879682'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '1703452'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '2416412'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '66965407'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '65403323'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '63924427'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '68922844'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '71212046'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '72266177'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '74201615'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '76428008'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '77780414'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '78329088'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '79944645'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '80043020'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '81762468'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '82245822'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '83866145'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '84382948'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '86101733'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '86387483'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '87802729'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '88682782'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '90134118'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '90425398'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '92449473'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '92204128'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '94253201'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '94149779'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '96027759'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '96980616'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '98416653'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '98667953'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '100988680'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '101267181'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '103549095'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '103789858'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '105763756'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '106064678'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '107535861'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '109067408'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '110028262'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '109311120'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '111854659'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '112108759'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '114286152'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '114434519'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '116937974'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '116760149'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '119540300'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '119645248'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '122095628'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '122409250'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '124954037'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '124719529'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '127815176'
update archive13F set
compid = '131003',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001066134'
where entryId = '128017311'
End Function
The Script is complete, exiting....