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: : 130880
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130880'
The Shares Amount is 247813000
The cusip is 495582108
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '495582108'
Number of Rows :206
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.12'
where entryId = '1224094'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.4'
where entryId = '1264888'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '255.34'
where entryId = '1569895'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '5.31'
where entryId = '1701207'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.01'
where entryId = '1827691'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.19'
where entryId = '2207731'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.49'
where entryId = '2282136'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '2307812'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '14.31'
where entryId = '2374504'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '9.27'
where entryId = '2832218'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '10.9'
where entryId = '3031557'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '2.17'
where entryId = '3505584'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '11.71'
where entryId = '3682691'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '131.02'
where entryId = '3730578'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.14'
where entryId = '3917161'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.3'
where entryId = '4574854'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.48'
where entryId = '5218222'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '6.58'
where entryId = '5264799'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.36'
where entryId = '6910538'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '4.75'
where entryId = '7306064'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.49'
where entryId = '7429224'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '2.59'
where entryId = '9157997'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '2.5'
where entryId = '9341745'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '2.75'
where entryId = '9755554'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '83.37'
where entryId = '10240153'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '11038463'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.61'
where entryId = '11065698'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '115.95'
where entryId = '11103239'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.02'
where entryId = '11125716'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.03'
where entryId = '11251120'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.63'
where entryId = '11265509'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '11274128'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '13.99'
where entryId = '11378757'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '20.89'
where entryId = '11449693'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '20.95'
where entryId = '11451554'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '10.16'
where entryId = '11894013'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '12116231'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '424.01'
where entryId = '12230620'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '2.16'
where entryId = '12287662'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.19'
where entryId = '12319292'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '12326731'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '31.04'
where entryId = '12389605'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '12424112'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.02'
where entryId = '12446553'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.61'
where entryId = '12475979'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '12562032'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.56'
where entryId = '12581893'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '12790842'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.6'
where entryId = '12846542'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.01'
where entryId = '12934502'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.05'
where entryId = '12972443'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.01'
where entryId = '12992343'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.16'
where entryId = '13023866'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '13455974'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.76'
where entryId = '13467932'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '13505184'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '13678043'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.86'
where entryId = '13681431'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.19'
where entryId = '13938573'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '14019475'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '3.25'
where entryId = '14074533'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.02'
where entryId = '14132593'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.64'
where entryId = '14231430'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.61'
where entryId = '14262597'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '14297283'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '5.36'
where entryId = '14327609'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '14552719'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '14575616'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.42'
where entryId = '14606152'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '12.06'
where entryId = '14636924'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.73'
where entryId = '14661397'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '4.62'
where entryId = '14662561'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.16'
where entryId = '14678993'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '14824753'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '7'
where entryId = '14875551'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.02'
where entryId = '14913162'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '14944264'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '68.23'
where entryId = '14950100'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.97'
where entryId = '14951978'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '87.4'
where entryId = '15090930'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.67'
where entryId = '15137040'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '15174925'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.14'
where entryId = '15258946'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '15261812'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '15279498'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.86'
where entryId = '15333246'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '15337007'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.02'
where entryId = '15450005'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.02'
where entryId = '15453543'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.59'
where entryId = '15473397'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '161.41'
where entryId = '15580616'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '2.11'
where entryId = '15632506'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.63'
where entryId = '15774829'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.02'
where entryId = '15914782'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '15983532'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '16106671'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.39'
where entryId = '16117596'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '3.1'
where entryId = '16175069'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.16'
where entryId = '16195321'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '16286580'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '16521251'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.67'
where entryId = '16552055'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.86'
where entryId = '16582462'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '16615172'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.07'
where entryId = '16682634'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.95'
where entryId = '16682964'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.95'
where entryId = '16683282'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.95'
where entryId = '16683596'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.56'
where entryId = '16703669'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.31'
where entryId = '16729201'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.13'
where entryId = '16763904'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.02'
where entryId = '16786651'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.99'
where entryId = '16835221'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '16920146'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '10.46'
where entryId = '16961535'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '17013069'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.23'
where entryId = '17015557'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.01'
where entryId = '17035526'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.62'
where entryId = '17044932'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '17074528'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '4.04'
where entryId = '17097683'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '17104414'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '5.28'
where entryId = '17135240'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '23.87'
where entryId = '17201437'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.62'
where entryId = '17275372'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.24'
where entryId = '17468438'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '3.29'
where entryId = '17484976'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '45.63'
where entryId = '17522006'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.61'
where entryId = '17523271'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.4'
where entryId = '17540862'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.1'
where entryId = '17542277'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.06'
where entryId = '17557828'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '17673253'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '17787549'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.22'
where entryId = '17978970'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '8.32'
where entryId = '17989701'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '18041537'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.51'
where entryId = '18048563'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.69'
where entryId = '18075777'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '18091492'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.86'
where entryId = '18116372'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.61'
where entryId = '18167377'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.13'
where entryId = '18181887'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '18293759'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.01'
where entryId = '18298341'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.63'
where entryId = '18383254'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '3.65'
where entryId = '18393828'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.4'
where entryId = '18402212'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '7.36'
where entryId = '18540556'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.01'
where entryId = '18541524'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '18551368'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '23.36'
where entryId = '18569386'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.25'
where entryId = '18572864'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '18658254'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.1'
where entryId = '18660486'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.78'
where entryId = '18672849'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '18711361'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '3.7'
where entryId = '18761527'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '9.73'
where entryId = '18805987'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '18842172'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.86'
where entryId = '18853952'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '181.59'
where entryId = '19048682'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.02'
where entryId = '19053832'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '47.01'
where entryId = '19105121'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.2'
where entryId = '19115811'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '8.66'
where entryId = '19116898'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.19'
where entryId = '19130671'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.12'
where entryId = '19148734'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '19237801'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '27.41'
where entryId = '19264173'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.02'
where entryId = '19269985'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.14'
where entryId = '19522746'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '19555568'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '3.27'
where entryId = '19556246'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.07'
where entryId = '19880489'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '4.62'
where entryId = '19884663'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '3.83'
where entryId = '20390327'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '20763420'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '21182454'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '22500020'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '22666493'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.81'
where entryId = '22686490'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.61'
where entryId = '22688298'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.4'
where entryId = '22738256'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.57'
where entryId = '22865430'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '33.24'
where entryId = '23173384'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '23425182'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '13.11'
where entryId = '23764860'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '60.53'
where entryId = '23925571'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '24012084'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '1.66'
where entryId = '24086946'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.04'
where entryId = '24138482'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '24521088'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '24921559'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '24926990'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '25.99'
where entryId = '27469568'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '28642171'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '28814305'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0.51'
where entryId = '28956491'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '29312376'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '29342664'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '9.99'
where entryId = '29403336'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '511.47'
where entryId = '29664036'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '29960886'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '31253032'
update current13Fpositions set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699' ,
percentOut = '0'
where entryId = '130459850'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '495582108'
Number of Rows :22
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '77781235'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '79945452'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '81762725'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '83866925'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '86102509'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '87803526'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '90134894'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '92204908'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '94253986'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '96028547'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '98417443'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '100989468'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '103549904'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '105764669'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '109068329'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '111855603'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '114287095'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '116761087'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '119646211'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '122410255'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '124955052'
update archive13F set
compid = '130880',
sectorNum = '401005',
sectorDes = 'Drug Manufacturers - Other',
issuerCik = '0001047699'
where entryId = '127816199'
End Function
The Script is complete, exiting....