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: : 138098
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '138098'
The Shares Amount is 17100000
The cusip is 68217C208
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '68217C208'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '68217C208'
Number of Rows :164
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '68285522'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '68232601'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '67706607'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '67960611'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '67830282'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '66705680'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '66746310'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '68464246'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '68905127'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69030556'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '68690131'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '68849499'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69727844'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '68719432'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '68883739'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69137855'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69328763'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69658361'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69792168'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69755879'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69812859'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69167145'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69160223'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69885965'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69195695'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69609073'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69948184'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69417747'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69952518'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '68792102'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69937984'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69379982'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69463373'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69711473'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69869517'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '69072406'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71246635'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70295178'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70250077'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70205988'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70366457'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70322205'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70626647'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70665378'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70727280'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70764520'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71028016'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71648721'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71653474'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70609152'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70741858'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70957172'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71535389'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71216449'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71233526'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71239629'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '70901163'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71748067'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71748130'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71085122'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71194193'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71417477'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71741813'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71006964'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71550244'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71393909'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71701090'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71174845'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '71329381'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72198363'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72373980'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72487596'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72650926'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72240942'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72156904'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72333293'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72530210'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72562185'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72876479'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72866863'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72053340'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73559165'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72829984'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72631430'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72305643'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72748606'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72813766'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73354018'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73427654'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72807207'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73371008'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73745489'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73148977'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72675552'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73271080'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73329072'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73025519'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73204392'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72717216'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73501183'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73665375'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73297229'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72557312'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '72861796'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '73748553'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74282055'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74670992'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74138014'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74517023'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74333642'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74663630'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74166201'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74229579'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74417124'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74407091'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75645654'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74560257'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75420861'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74608141'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74694647'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75596914'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75126643'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75614589'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75145241'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74871476'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75635533'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75012480'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75066934'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75674885'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75382605'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74936690'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '74361791'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75238033'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75528860'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75089514'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '75640343'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76760538'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76253984'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76003222'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76257757'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76760069'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76761394'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76763027'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76764335'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77631454'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76764727'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76044793'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77624474'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77628522'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77629307'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76763878'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77631127'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77630861'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77631699'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76761849'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77680074'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77630571'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77630323'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77624042'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77628781'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '77595065'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '76763752'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '78220300'
update archive13F set
compid = '138098',
sectorNum = '102002',
sectorDes = 'Business Equipment',
issuerCik = '0001097792'
where entryId = '78566523'
End Function
The Script is complete, exiting....