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: : 151572
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '151572'
The Shares Amount is 450151000
The cusip is G2554F113
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G2554F113'
Number of Rows :265
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.69'
where entryId = '31305916'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.39'
where entryId = '31507987'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '108.25'
where entryId = '31774076'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '17.26'
where entryId = '31799052'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.07'
where entryId = '31891506'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.43'
where entryId = '32166020'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '53.43'
where entryId = '32454973'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.03'
where entryId = '32808762'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.02'
where entryId = '32840190'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '32962878'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.86'
where entryId = '32981080'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '33166783'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '7.87'
where entryId = '33231671'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '44.43'
where entryId = '33239400'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.33'
where entryId = '33324680'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.29'
where entryId = '33874270'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.33'
where entryId = '34509097'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.94'
where entryId = '34540611'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '2.12'
where entryId = '34689169'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.2'
where entryId = '34876490'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.03'
where entryId = '35073720'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.37'
where entryId = '35371278'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '35414113'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.03'
where entryId = '35470085'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.07'
where entryId = '35849503'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '36600050'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.03'
where entryId = '36732855'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.09'
where entryId = '38075669'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.62'
where entryId = '38323948'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.22'
where entryId = '38845063'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.23'
where entryId = '38961594'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '2.06'
where entryId = '39136422'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '5.27'
where entryId = '39292943'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.02'
where entryId = '39322788'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.38'
where entryId = '39431769'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.11'
where entryId = '39721969'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '5.56'
where entryId = '39845780'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.06'
where entryId = '40849212'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.13'
where entryId = '40875359'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.13'
where entryId = '41182013'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '5.44'
where entryId = '41650850'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.06'
where entryId = '41674296'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1'
where entryId = '42050140'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '9.14'
where entryId = '42058829'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.77'
where entryId = '42059097'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42060988'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.65'
where entryId = '42062304'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.08'
where entryId = '42068665'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.09'
where entryId = '42068878'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '2.46'
where entryId = '42069682'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.25'
where entryId = '42071014'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.15'
where entryId = '42071466'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.48'
where entryId = '42071899'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.18'
where entryId = '42073158'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.19'
where entryId = '42073670'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '2.9'
where entryId = '42073968'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '2.83'
where entryId = '42075019'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.4'
where entryId = '42075318'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.29'
where entryId = '42077705'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.07'
where entryId = '42079534'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42080381'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.13'
where entryId = '42081300'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.18'
where entryId = '42082956'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.15'
where entryId = '42083140'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.05'
where entryId = '42084589'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.38'
where entryId = '42086067'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.12'
where entryId = '42086684'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.95'
where entryId = '42087344'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.14'
where entryId = '42087770'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.34'
where entryId = '42089206'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.11'
where entryId = '42089738'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.15'
where entryId = '42090393'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '2.79'
where entryId = '42092244'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.03'
where entryId = '42094028'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42097229'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '25.27'
where entryId = '42097454'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.44'
where entryId = '42098446'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.12'
where entryId = '42098720'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.24'
where entryId = '42102718'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.11'
where entryId = '42102983'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '4.42'
where entryId = '42103662'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '18.21'
where entryId = '42105506'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '15.84'
where entryId = '42108027'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.72'
where entryId = '42110011'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.07'
where entryId = '42111778'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.08'
where entryId = '42111831'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.56'
where entryId = '42112472'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.34'
where entryId = '42113613'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.48'
where entryId = '42114508'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.07'
where entryId = '42115795'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '7.47'
where entryId = '42116846'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '5.04'
where entryId = '42120327'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '2.11'
where entryId = '42120617'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.8'
where entryId = '42121231'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.62'
where entryId = '42122547'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '5.8'
where entryId = '42125201'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '7.49'
where entryId = '42125994'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.62'
where entryId = '42126458'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.1'
where entryId = '42131792'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '2.52'
where entryId = '42133295'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.3'
where entryId = '42134553'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.63'
where entryId = '42135079'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.09'
where entryId = '42135611'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.11'
where entryId = '42137103'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.71'
where entryId = '42137660'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.2'
where entryId = '42138440'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.51'
where entryId = '42139352'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.56'
where entryId = '42141103'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '2.59'
where entryId = '42144237'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.69'
where entryId = '42145510'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42147806'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.38'
where entryId = '42148865'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.16'
where entryId = '42150196'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.01'
where entryId = '42152337'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.03'
where entryId = '42153554'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.46'
where entryId = '42154393'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '106.66'
where entryId = '42155210'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.08'
where entryId = '42156129'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.16'
where entryId = '42156584'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.23'
where entryId = '42159176'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.84'
where entryId = '42159540'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.03'
where entryId = '42160128'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.13'
where entryId = '42161180'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.86'
where entryId = '42161992'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.8'
where entryId = '42162594'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.33'
where entryId = '42164213'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42165091'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '5.58'
where entryId = '42165641'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.3'
where entryId = '42166175'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42169368'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.4'
where entryId = '42170278'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.06'
where entryId = '42173888'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '4.63'
where entryId = '42174612'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.09'
where entryId = '42179166'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.57'
where entryId = '42179588'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '7.4'
where entryId = '42179937'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.62'
where entryId = '42182691'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '4.56'
where entryId = '42183504'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '4.79'
where entryId = '42183735'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '6.38'
where entryId = '42184182'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.23'
where entryId = '42185459'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '7'
where entryId = '42186381'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.36'
where entryId = '42190799'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42191654'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '4.74'
where entryId = '42195690'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.02'
where entryId = '42196312'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42198586'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.23'
where entryId = '42199206'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.08'
where entryId = '42199923'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.25'
where entryId = '42204071'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.3'
where entryId = '42205018'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.29'
where entryId = '42205919'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42206583'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42207077'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.16'
where entryId = '42207686'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.66'
where entryId = '42207863'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42208129'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42209294'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42209468'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.16'
where entryId = '42209944'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '2.16'
where entryId = '42210212'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.3'
where entryId = '42210369'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42211966'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.05'
where entryId = '42214828'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.12'
where entryId = '42217084'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.87'
where entryId = '42218481'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '6.53'
where entryId = '42218676'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.69'
where entryId = '42220685'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '22.93'
where entryId = '42222768'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '6.54'
where entryId = '42226325'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '17.58'
where entryId = '42226741'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.21'
where entryId = '42229686'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '19.16'
where entryId = '42230495'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '9.65'
where entryId = '42230649'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.25'
where entryId = '42230785'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.64'
where entryId = '42231035'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '12.69'
where entryId = '42231777'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.16'
where entryId = '42233956'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42235815'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.09'
where entryId = '42237643'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.33'
where entryId = '42239103'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '40.12'
where entryId = '42239636'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42239895'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.01'
where entryId = '42241139'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.93'
where entryId = '42241548'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '2.07'
where entryId = '42241612'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.74'
where entryId = '42243743'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.07'
where entryId = '42243885'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.75'
where entryId = '42246488'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.48'
where entryId = '42247533'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '7.96'
where entryId = '42248722'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.33'
where entryId = '42249797'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '19.34'
where entryId = '42250492'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.96'
where entryId = '42251091'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.12'
where entryId = '42252112'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.37'
where entryId = '42253605'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '42258081'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42265304'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42265595'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42267082'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42267705'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42269197'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42269889'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42459605'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42460450'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42460958'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42461370'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42463427'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42465479'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42466897'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '42467467'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.19'
where entryId = '43511920'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '8.56'
where entryId = '44142030'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '44901783'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.86'
where entryId = '45418871'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '34.42'
where entryId = '45834420'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.24'
where entryId = '46116648'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '46318158'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '11.2'
where entryId = '46540194'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.21'
where entryId = '47143280'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.03'
where entryId = '47250812'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.34'
where entryId = '47280649'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.12'
where entryId = '47333375'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.21'
where entryId = '47725758'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '9.98'
where entryId = '47969129'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '6'
where entryId = '48061916'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.74'
where entryId = '48477830'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '2.66'
where entryId = '49101420'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.86'
where entryId = '49294433'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '49520815'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '49527674'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.42'
where entryId = '49584049'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.09'
where entryId = '50096958'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.58'
where entryId = '50196649'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.36'
where entryId = '50213826'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.34'
where entryId = '50433629'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '50525055'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '50527673'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '4.43'
where entryId = '50672476'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '24.5'
where entryId = '51209591'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '53.06'
where entryId = '51244879'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '1.66'
where entryId = '51443063'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '4.84'
where entryId = '51508809'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.71'
where entryId = '51622440'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.08'
where entryId = '51685884'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.31'
where entryId = '51751877'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '52019820'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '52243107'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '52579979'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.22'
where entryId = '52914539'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '53263318'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.96'
where entryId = '53429220'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '3.06'
where entryId = '53469628'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '4.28'
where entryId = '53517891'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.07'
where entryId = '53598958'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0.01'
where entryId = '53611989'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '53779152'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '53781522'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '53986674'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '54220317'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '54228038'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '54549515'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '54565487'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '58608175'
update current13Fpositions set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187' ,
percentOut = '0'
where entryId = '61627157'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G2554F113'
Number of Rows :32
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '47662990'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '65230434'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '63362157'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '50892226'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '79608379'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '79607012'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '32176174'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '90818151'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '92081744'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '92573302'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '43484696'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '51036831'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '94376168'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '43898014'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '95213456'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '96632380'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '96563141'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '97563351'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '45092153'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '98790857'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '100607673'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '100820892'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '103293104'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '115256237'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '115255798'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '115255410'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '115255027'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '115254648'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '115944394'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '115256671'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '34972842'
update archive13F set
compid = '151572',
sectorNum = '402006',
sectorDes = 'Medical Instruments & Supplies',
issuerCik = '0001385187'
where entryId = '129670270'
End Function
The Script is complete, exiting....