<BR><font color="#0066FF"> To do multible compids, use the following script:</font><BR>php /var/www/html_j3sg/institutions/ChangeCompidOfAllInstitutionalAfewCompaniesAtATime.php<BR><font color="#00000"> Please note that the script mentioned above (ChangeCompidOfAllInstitutionalAfewCompaniesAtATime) only updates the current13FFilingpositions table, no archived tables.</font><BR><BR><font color="#0066FF"> This script actual updates 13F current table as well as both archive13F tables.</font><BR><BR>We got coming in compid: : 134684<BR>SELECT companies.* , sectors.level3des
							FROM companies, sectors
							WHERE companies.sector = sectors.level3num and compid = '134684'<BR><BR>The Shares Amount is 17854000<BR><BR>The cusip is 879690105<BR>NOT OLD<BR><BR>Retrive Rows from Table:<BR>select * from current13Fpositions where cusip = '879690105'<BR>Number of Rows :51<BR><BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0'
						where  entryId = '15132736'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '23.47'
						where  entryId = '15199128'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '34.61'
						where  entryId = '15257063'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '5.75'
						where  entryId = '15260062'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.11'
						where  entryId = '15461405'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '9.86'
						where  entryId = '15591415'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.13'
						where  entryId = '15619281'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.84'
						where  entryId = '15730729'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '43.16'
						where  entryId = '15761564'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.01'
						where  entryId = '16110998'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '6.79'
						where  entryId = '16174689'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.17'
						where  entryId = '16196790'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0'
						where  entryId = '16288560'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.51'
						where  entryId = '16611243'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.06'
						where  entryId = '16673423'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '5.75'
						where  entryId = '16765105'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0'
						where  entryId = '16793008'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '6.5'
						where  entryId = '16834047'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '22.74'
						where  entryId = '16848846'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.01'
						where  entryId = '16874213'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '2471.07'
						where  entryId = '16961927'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.11'
						where  entryId = '17098737'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0'
						where  entryId = '17104855'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '48.06'
						where  entryId = '17207047'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '9.86'
						where  entryId = '17440094'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '5.94'
						where  entryId = '17468769'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.52'
						where  entryId = '17558288'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0'
						where  entryId = '17675314'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0'
						where  entryId = '17786423'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.17'
						where  entryId = '17980440'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '19.12'
						where  entryId = '18154410'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '1.28'
						where  entryId = '18183026'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.05'
						where  entryId = '18252897'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.01'
						where  entryId = '18261420'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '3.81'
						where  entryId = '18265882'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0'
						where  entryId = '18274440'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.11'
						where  entryId = '18304791'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.01'
						where  entryId = '18356351'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '6.5'
						where  entryId = '18375531'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '1063.48'
						where  entryId = '18540895'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0'
						where  entryId = '18658687'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '9.86'
						where  entryId = '18777410'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.39'
						where  entryId = '19054969'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.24'
						where  entryId = '19150195'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0'
						where  entryId = '19239840'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.84'
						where  entryId = '23146537'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.2'
						where  entryId = '23159779'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '30.87'
						where  entryId = '23178253'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0.06'
						where  entryId = '24138884'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '0'
						where  entryId = '24522635'<BR>update current13Fpositions set 
						compid  = '134684', 
						sectorNum  = '102002', 
						sectorDes  = 'Business Equipment', 
						issuerCik  = '' ,
						percentOut = '8.51'
						where  entryId = '45620389'<BR>End Function<BR><BR>Retrive Rows from Table:<BR>select * from archive13F where cusip = '879690105'<BR>Number of Rows :0<BR><BR>End Function<BR>The Script is complete, exiting....