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: : 130597
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130597'
The Shares Amount is 64248000
The cusip is 795435106
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '795435106'
Number of Rows :153
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.57'
where entryId = '1265363'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '1599544'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '14.79'
where entryId = '1793016'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.07'
where entryId = '1828104'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.46'
where entryId = '3506846'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.88'
where entryId = '3682867'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '10.31'
where entryId = '3733310'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '4416954'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '4436214'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '6.47'
where entryId = '5140957'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '6253004'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '3.72'
where entryId = '9756969'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '94.53'
where entryId = '10248031'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.05'
where entryId = '11068414'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.16'
where entryId = '11266334'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.19'
where entryId = '12288624'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '12327411'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '12561877'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.16'
where entryId = '12847371'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '6.91'
where entryId = '13021023'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.35'
where entryId = '13243042'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '32.42'
where entryId = '13457226'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.36'
where entryId = '13468259'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.05'
where entryId = '13625821'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.05'
where entryId = '13626140'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.05'
where entryId = '13626502'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.05'
where entryId = '13626919'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.05'
where entryId = '13627307'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.23'
where entryId = '13627812'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '13678731'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '13818537'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '130.34'
where entryId = '14052558'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.03'
where entryId = '14266553'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '1.89'
where entryId = '14310450'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '4.18'
where entryId = '14328331'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.36'
where entryId = '14661815'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '14826702'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.14'
where entryId = '14877923'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '15262501'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '3.8'
where entryId = '15450499'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '433.35'
where entryId = '15593996'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '151.97'
where entryId = '15787056'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.05'
where entryId = '16110965'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.14'
where entryId = '16118012'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.41'
where entryId = '16353513'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.41'
where entryId = '16354767'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '16615869'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '3.78'
where entryId = '16835730'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.05'
where entryId = '16874177'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '13.11'
where entryId = '16963635'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.59'
where entryId = '17016313'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '17075048'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '16.17'
where entryId = '17205878'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '133.87'
where entryId = '17458860'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.14'
where entryId = '17541289'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.3'
where entryId = '17728313'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.08'
where entryId = '18261391'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '3.94'
where entryId = '18298836'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '1.97'
where entryId = '18493455'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '6.3'
where entryId = '19064878'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '66.12'
where entryId = '19078651'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.04'
where entryId = '19116229'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.48'
where entryId = '21273974'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '5.13'
where entryId = '22686540'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.01'
where entryId = '23176990'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '24015318'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '4.24'
where entryId = '24066549'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '24522224'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '11.67'
where entryId = '24822070'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '24921819'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '24927560'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '26905351'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '7.76'
where entryId = '29137621'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '29681524'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '29689563'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '31253614'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '3.84'
where entryId = '31800111'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '26.81'
where entryId = '31890290'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '311.29'
where entryId = '32455002'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '8.08'
where entryId = '32908539'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '18.62'
where entryId = '33104193'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '35270066'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '9.63'
where entryId = '35849158'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '54.48'
where entryId = '36042450'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.78'
where entryId = '38467297'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '3.16'
where entryId = '38909581'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '27.24'
where entryId = '39908487'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '21.23'
where entryId = '40850962'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '41123419'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '11.56'
where entryId = '41652132'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.92'
where entryId = '41675349'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.83'
where entryId = '42065251'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.63'
where entryId = '42068372'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.04'
where entryId = '42084003'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.58'
where entryId = '42087511'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.11'
where entryId = '42090156'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.53'
where entryId = '42093504'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '215.24'
where entryId = '42100009'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '1.76'
where entryId = '42101319'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '16.63'
where entryId = '42107138'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '1.77'
where entryId = '42115238'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '17.02'
where entryId = '42125905'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '6.3'
where entryId = '42138111'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '1.77'
where entryId = '42138652'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '1.08'
where entryId = '42140404'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.37'
where entryId = '42146810'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.62'
where entryId = '42149734'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.16'
where entryId = '42150675'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '45.89'
where entryId = '42151294'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '19.91'
where entryId = '42152897'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.18'
where entryId = '42153163'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.61'
where entryId = '42158824'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.97'
where entryId = '42163730'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '6.05'
where entryId = '42165193'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.98'
where entryId = '42172378'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.03'
where entryId = '42174178'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '14.89'
where entryId = '42175066'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '3.3'
where entryId = '42178343'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.11'
where entryId = '42182029'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.38'
where entryId = '42191129'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.01'
where entryId = '42201428'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.06'
where entryId = '42203601'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '41.63'
where entryId = '42222817'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.67'
where entryId = '42225743'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '1.29'
where entryId = '42227517'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '279.87'
where entryId = '42231405'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '11.48'
where entryId = '42237383'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '1.19'
where entryId = '42243402'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '73.97'
where entryId = '42244680'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '7.16'
where entryId = '42246215'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '24.64'
where entryId = '42247371'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '20.32'
where entryId = '42248091'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.91'
where entryId = '42251771'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '7.13'
where entryId = '42253219'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '42463049'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '42470224'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '42685569'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.58'
where entryId = '43979707'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.64'
where entryId = '45516197'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.77'
where entryId = '46318248'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '11.82'
where entryId = '46539175'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '2.82'
where entryId = '49294686'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '1.4'
where entryId = '49941387'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.26'
where entryId = '50097143'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '10.21'
where entryId = '50672689'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '8.82'
where entryId = '51216013'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.5'
where entryId = '51524631'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0.18'
where entryId = '51751690'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '7'
where entryId = '52914590'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '6.23'
where entryId = '53469676'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '5.45'
where entryId = '53517907'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '53592836'
update current13Fpositions set
compid = '130597',
sectorNum = '401006',
sectorDes = 'Drug Related Products',
issuerCik = '0001009356' ,
percentOut = '0'
where entryId = '56832971'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '795435106'
Number of Rows :0
End Function
The Script is complete, exiting....