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: : 151504
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '151504'
The Shares Amount is 68891000
The cusip is 83421A104
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '83421A104'
Number of Rows :143
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.23'
where entryId = '9757147'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '99.43'
where entryId = '10068135'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '69.93'
where entryId = '10248959'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '11115938'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '12192333'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.25'
where entryId = '12288783'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '3'
where entryId = '12934956'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.01'
where entryId = '12987396'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '12.49'
where entryId = '13243084'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '211.42'
where entryId = '13471289'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '13671498'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '5.26'
where entryId = '13717983'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '13818535'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.12'
where entryId = '14129257'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '17.22'
where entryId = '14310499'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '12.82'
where entryId = '14328426'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '235.66'
where entryId = '14665596'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.12'
where entryId = '14878212'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '6.52'
where entryId = '15070489'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '5.08'
where entryId = '15161669'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '15263399'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '106.27'
where entryId = '15387536'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '12.3'
where entryId = '15478649'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.01'
where entryId = '16196598'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '2.19'
where entryId = '16543748'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '16616820'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '121.94'
where entryId = '16673741'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.78'
where entryId = '16729871'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '7.56'
where entryId = '16764948'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '5.42'
where entryId = '16776240'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.14'
where entryId = '16939361'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.6'
where entryId = '17016403'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '17075108'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '17105300'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.02'
where entryId = '17108325'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '1.1'
where entryId = '17135343'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '5.81'
where entryId = '17145095'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '86.84'
where entryId = '17206368'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '15.89'
where entryId = '17210937'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '12.48'
where entryId = '17276003'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '17786508'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '2.78'
where entryId = '18051191'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '24.83'
where entryId = '18175266'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '4.64'
where entryId = '18182866'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '21.51'
where entryId = '18184312'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '128.96'
where entryId = '18253172'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '3.4'
where entryId = '18373957'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '39.84'
where entryId = '18493498'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.81'
where entryId = '18570137'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '18659120'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.03'
where entryId = '18660880'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.09'
where entryId = '19054793'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.89'
where entryId = '19149988'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '82.4'
where entryId = '20167234'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '564.16'
where entryId = '20169002'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '20472494'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '7.09'
where entryId = '20791562'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '4.7'
where entryId = '21200260'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '31.88'
where entryId = '22005238'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '4.11'
where entryId = '22686549'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '53.79'
where entryId = '23177455'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.19'
where entryId = '24138823'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '24522382'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.17'
where entryId = '28749172'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.61'
where entryId = '29135805'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '29832225'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '29960297'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '31253789'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '1.49'
where entryId = '31412828'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.2'
where entryId = '31800172'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '3.28'
where entryId = '32167374'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.04'
where entryId = '32840365'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.23'
where entryId = '32908600'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '15.11'
where entryId = '33324974'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '33878627'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '15.13'
where entryId = '34508985'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.73'
where entryId = '34674584'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '35414046'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.29'
where entryId = '35470479'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.07'
where entryId = '38324443'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.36'
where entryId = '40850684'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '26.03'
where entryId = '41186515'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '7.23'
where entryId = '41652225'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '5.28'
where entryId = '41675425'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.23'
where entryId = '42067335'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '1.15'
where entryId = '42068632'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.15'
where entryId = '42084027'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '7.45'
where entryId = '42093596'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '21.62'
where entryId = '42096136'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '42096909'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '127.36'
where entryId = '42100021'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '23.86'
where entryId = '42102768'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '1.13'
where entryId = '42104007'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '17.43'
where entryId = '42107239'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '82.97'
where entryId = '42109540'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '1.07'
where entryId = '42115293'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '254.09'
where entryId = '42132399'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.01'
where entryId = '42133868'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.88'
where entryId = '42146903'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '2.1'
where entryId = '42151321'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.2'
where entryId = '42158879'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.03'
where entryId = '42168989'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.94'
where entryId = '42172425'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.12'
where entryId = '42182088'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '1.28'
where entryId = '42184661'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '144.78'
where entryId = '42192421'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '4.93'
where entryId = '42223082'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '8.47'
where entryId = '42225831'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '1.01'
where entryId = '42227568'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '39.19'
where entryId = '42228254'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '8.85'
where entryId = '42230468'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '26.03'
where entryId = '42234965'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '37.29'
where entryId = '42236513'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '1.78'
where entryId = '42237420'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.58'
where entryId = '42244053'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '1.19'
where entryId = '42246251'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '31.72'
where entryId = '42248103'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.91'
where entryId = '42251828'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '5.94'
where entryId = '42253252'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '42459154'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '42685986'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '82.97'
where entryId = '43579083'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.56'
where entryId = '43980322'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '2.51'
where entryId = '46540044'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '1.31'
where entryId = '47969500'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '1.16'
where entryId = '49294685'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.86'
where entryId = '49941411'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '3.86'
where entryId = '50673063'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '246.56'
where entryId = '50844381'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '4.08'
where entryId = '51216381'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '52003119'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.86'
where entryId = '53301565'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '2.34'
where entryId = '53430191'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '46.2'
where entryId = '56366821'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0.52'
where entryId = '57842092'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '58112149'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '2.67'
where entryId = '59840011'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '60056955'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '60081373'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '60388544'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '60816000'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '61617819'
update current13Fpositions set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245' ,
percentOut = '0'
where entryId = '61628596'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '83421A104'
Number of Rows :9
update archive13F set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245'
where entryId = '90817229'
update archive13F set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245'
where entryId = '92572335'
update archive13F set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245'
where entryId = '94375138'
update archive13F set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245'
where entryId = '96562063'
update archive13F set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245'
where entryId = '98789714'
update archive13F set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245'
where entryId = '100819706'
update archive13F set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245'
where entryId = '103291405'
update archive13F set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245'
where entryId = '57269433'
update archive13F set
compid = '151504',
sectorNum = '602002',
sectorDes = 'Business Software & Services',
issuerCik = '0001324245'
where entryId = '109972941'
End Function
The Script is complete, exiting....