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: : 130725
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130725'
The Shares Amount is 48500000
The cusip is 03073T102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '03073T102'
Number of Rows :122
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '1366927'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.02'
where entryId = '1827045'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '3167934'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '1.44'
where entryId = '3503295'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.64'
where entryId = '3726018'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.06'
where entryId = '3846477'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2.89'
where entryId = '3918041'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '29.36'
where entryId = '4112968'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '4416975'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '4436255'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.21'
where entryId = '5086600'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2.01'
where entryId = '5217245'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '5580394'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '1.01'
where entryId = '9753247'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '9987225'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '419.61'
where entryId = '10226837'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2.71'
where entryId = '11076810'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '245.66'
where entryId = '11102640'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '11115489'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '88.43'
where entryId = '11424607'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '40.42'
where entryId = '11449016'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '49.24'
where entryId = '11451466'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '3.75'
where entryId = '11794084'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '11984359'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.17'
where entryId = '12187878'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '21.46'
where entryId = '12228334'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '1.88'
where entryId = '12286240'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '12328162'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.84'
where entryId = '12972369'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '11.94'
where entryId = '12986744'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '3.36'
where entryId = '13261922'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '1.29'
where entryId = '13468555'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '13679467'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.09'
where entryId = '13937090'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '3.36'
where entryId = '14033209'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '6.25'
where entryId = '14106386'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '23.67'
where entryId = '14326373'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '12.17'
where entryId = '14332401'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '1.29'
where entryId = '14660727'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '22.97'
where entryId = '14662487'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '18.48'
where entryId = '14871745'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '15086942'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '1.59'
where entryId = '15104992'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '12.57'
where entryId = '15212598'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '15263230'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '15279523'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '5.64'
where entryId = '15449206'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.18'
where entryId = '15472223'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '3.24'
where entryId = '15503178'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '638.85'
where entryId = '15593869'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2.87'
where entryId = '16006015'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '50.82'
where entryId = '16103536'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.48'
where entryId = '16116930'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '16615441'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '5.52'
where entryId = '16834454'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '27.02'
where entryId = '16908449'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '16955602'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '604.88'
where entryId = '16963511'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2'
where entryId = '16978467'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.88'
where entryId = '17014312'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '17073687'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '17105017'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '1.73'
where entryId = '17158037'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.02'
where entryId = '17162069'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '9.68'
where entryId = '17194495'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '9.3'
where entryId = '17274392'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '3.15'
where entryId = '17383412'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '9.8'
where entryId = '17432802'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '44.92'
where entryId = '17521889'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.48'
where entryId = '17540183'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.74'
where entryId = '17542200'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.02'
where entryId = '17557281'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '17786839'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '18009447'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2.57'
where entryId = '18065917'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2.31'
where entryId = '18252970'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '18273149'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2.95'
where entryId = '18292710'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '5.75'
where entryId = '18297552'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.16'
where entryId = '18355060'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2.74'
where entryId = '18567399'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '22.29'
where entryId = '18568218'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '18658837'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '580.45'
where entryId = '19064754'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '70.86'
where entryId = '19105038'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.42'
where entryId = '19115139'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '16.28'
where entryId = '19116805'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.19'
where entryId = '19880113'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2.03'
where entryId = '22865337'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '5.51'
where entryId = '23078117'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '8.58'
where entryId = '23167445'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '24505338'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '24519131'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '24916590'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '24928125'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2.32'
where entryId = '25414826'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '12.91'
where entryId = '26245469'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '13.01'
where entryId = '27478646'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '28132675'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.03'
where entryId = '28778946'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '4.12'
where entryId = '28836486'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '29689573'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '31252724'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2.1'
where entryId = '31412677'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '4.32'
where entryId = '31798666'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '8.23'
where entryId = '31890743'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '3.14'
where entryId = '32165553'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '32575071'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.23'
where entryId = '32907333'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '1.05'
where entryId = '34045218'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '5.92'
where entryId = '34508472'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '34744952'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '4.23'
where entryId = '35443719'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '35975062'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '1.86'
where entryId = '38299443'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0.43'
where entryId = '38323783'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '1.01'
where entryId = '38533761'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '4.1'
where entryId = '38547022'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '2.22'
where entryId = '38693734'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '40897101'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '41122884'
update current13Fpositions set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863' ,
percentOut = '0'
where entryId = '130458062'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '03073T102'
Number of Rows :27
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '3688063'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '4399272'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '5240360'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '77779805'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '79944040'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '81762581'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '83865540'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '86101148'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '15544031'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '87802145'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '88928617'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '90133556'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '92203584'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '94252650'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '96027202'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '98416083'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '100988113'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '103548509'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '105763090'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '109066729'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '111853974'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '114285462'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '116759464'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '119644542'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '122408522'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '124953301'
update archive13F set
compid = '130725',
sectorNum = '402001',
sectorDes = 'Health Care Plans',
issuerCik = '0001064863'
where entryId = '127814437'
End Function
The Script is complete, exiting....