use pvsmaster_gent070825

select * from AddressMaster where ExactERPAddressId in (1885, 1876, 1871, 1887, 2177)

ALTER TABLE AddressMaster
ADD CityMapping VARCHAR(500) DEFAULT '' NOT NULL;


update AddressMaster set CityMapping=City

select * from AddressMaster  where Id in (2701, 2855)

select Id, City, CityMapping from AddressMaster where ExactERPAddressId in (1885, 1876, 1871, 1887, 2177)

update AddressMaster set CityMapping='Corbeilles,En-Gatinais,Corbeilles-En-Gatinais' where Id=2701
update AddressMaster set CityMapping='Fontaine,Le Dun,Fontaine Le Dun' where Id=2855
update AddressMaster set CityMapping='Pithiviers,Le Vieil,Pithiviers Le Vieil' where Id=3305
update AddressMaster set CityMapping='Villers,Faucon,Villers Faucon' where Id=3527
update AddressMaster set CityMapping='Villette-Sur-Aube' where Id=3531


select * from TransportPriceMasterBKP150725 where DestinationCity like '%Swansea%' and  TransporterId=2

select * from TransportPriceMaster where ChemicalName='H2so4'

select * from TransportPriceMaster where ChemicalName='H2so4' DilutionFrom or DilutionTo between 35 and 40

SELECT *
FROM TransportPriceMaster
WHERE ChemicalName = 'NaHSO3'
  AND (
        DilutionFrom BETWEEN 35 AND 40
        OR DilutionTo BETWEEN 35 AND 40
      );

UPDATE TransportPriceMaster SET DilutionFrom=38 , DilutionTo=40
WHERE ChemicalName = 'NaHSO3'
  AND (
        DilutionFrom BETWEEN 35 AND 40
        OR DilutionTo BETWEEN 35 AND 40
      );


select * from ProductMaster

ALTER TABLE ProductMaster
ADD ProductName VARCHAR(500) NOT NULL DEFAULT '';

UPDATE ProductMaster SET ProductName = 'AMMONIUM BISULFITE SOLUTION 65%' WHERE FullName = 'AMMONIUMBISULFIET OPLOSSING 65%';
UPDATE ProductMaster SET ProductName = 'AMMONIUM BISULFITE SOLUTION 70%' WHERE FullName = 'AMMONIUMBISULFIET OPLOSSING 70%';
UPDATE ProductMaster SET ProductName = 'SODIUM BISULFITE SOLUTION 39%' WHERE FullName = 'NATRIUMBISULFIET OPLOSSING 39%';
UPDATE ProductMaster SET ProductName = 'SODIUM BISULFITE SOLUTION 39% FOOD GRADE' WHERE FullName = 'NATRIUMBISULFIET OPLOSSING 39% FOOD GRADE';
UPDATE ProductMaster SET ProductName = 'SODIUM BISULFITE SOLUTION 39%' WHERE FullName = 'NATRIUMBISULFIET OPLOSSING 39 %';
UPDATE ProductMaster SET ProductName = 'SODIUM BISULFITE SOLUTION 36%' WHERE FullName = 'NATRIUMBISULFIET OPLOSSING 36%';
UPDATE ProductMaster SET ProductName = 'AMMONIUM BISULFITE SOLUTION 70%  ' WHERE FullName = 'AMMONIUMBISULFIET OPLOSSING 70% trading';
UPDATE ProductMaster SET ProductName = 'OLEUM 20%' WHERE FullName = 'OLEUM 20%';
UPDATE ProductMaster SET ProductName = 'OLEUM 25%' WHERE FullName = 'OLEUM 25%';
UPDATE ProductMaster SET ProductName = 'OLEUM 30%' WHERE FullName = 'OLEUM 30%';
UPDATE ProductMaster SET ProductName = 'OLEUM 4.5%' WHERE FullName = 'OLEUM 4,5%';
UPDATE ProductMaster SET ProductName = 'OLEUM 20%' WHERE FullName = 'OLEUM 20%';
UPDATE ProductMaster SET ProductName = 'OLEUM 25%' WHERE FullName = 'OLEUM 25%';
UPDATE ProductMaster SET ProductName = 'OLEUM 30%' WHERE FullName = 'OLEUM 30%';
UPDATE ProductMaster SET ProductName = 'OLEUM 65% ' WHERE FullName = 'OLEUM 65% trading';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 92%' WHERE FullName = 'ZWAVELZUUR 92%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 96%' WHERE FullName = 'ZWAVELZUUR 96%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 98%' WHERE FullName = 'ZWAVELZUUR 98%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 94%' WHERE FullName = 'ZWAVELZUUR 94%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 95%' WHERE FullName = 'ZWAVELZUUR 95%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 93% FOOD GRADE' WHERE FullName = 'ZWAVELZUUR 93% FOOD GRADE';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 96% FOOD GRADE' WHERE FullName = 'ZWAVELZUUR 96 % FOOD GRADE';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 98% FOOD GRADE' WHERE FullName = 'ZWAVELZUUR 98% FOOD GRADE';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 92% ' WHERE FullName = 'ZWAVELZUUR 92% trading';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 96% ' WHERE FullName = 'ZWAVELZUUR 96% trading';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 98% ' WHERE FullName = 'ZWAVELZUUR 98% trading';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 96% ' WHERE FullName = 'ZWAVELZUUR 96% trading';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID PG 96%' WHERE FullName = 'ZWAVELZUUR PG 96%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID PG 95% ' WHERE FullName = 'ZWAVELZUUR PG 95% trading';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID PG 50%' WHERE FullName = 'ZWAVELZUUR PG 50%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 6N 25%' WHERE FullName = 'ZWAVELZUUR 6N 25%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID PG 90%' WHERE FullName = 'ZWAVELZUUR PG 90%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID CP 96%' WHERE FullName = 'ZWAVELZUUR CP 96%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID CP 96% ' WHERE FullName = 'ZWAVELZUUR CP 96% trading';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID EG 96%' WHERE FullName = 'ZWAVELZUUR EG 96%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID EG 96% ' WHERE FullName = 'ZWAVELZUUR EG 96% trading';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID EG 88%' WHERE FullName = 'ZWAVELZUUR EG 88%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID CP 45%' WHERE FullName = 'ZWAVELZUUR CP 45%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID PG 35%' WHERE FullName = 'ZWAVELZUUR PG 35%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID PG 20%' WHERE FullName = 'ZWAVELZUUR PG 20%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID CP 37.50%' WHERE FullName = 'ZWAVELZUUR CP 37,50%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID CP 98%' WHERE FullName = 'ZWAVELZUUR CP 98%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID EG 98%' WHERE FullName = 'ZWAVELZUUR EG 98%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID CP 50% AND EG 50%' WHERE FullName = 'ZWAVELZUUR CP 50% EN EG 50 %';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID TECHNICAL PURE 96%' WHERE FullName = 'ZWAVELZUUR TECHNICAL PURE 96%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID UHP 96%' WHERE FullName = 'ZWAVELZUUR UHP 96%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID UHP 97%' WHERE FullName = 'ZWAVELZUUR UHP 97%';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID UHP 98%' WHERE FullName = 'ZWAVELZUUR UHP 98%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 10%' WHERE FullName = 'ZWAVELZUUR VERDUND 10%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 38%' WHERE FullName = 'ZWAVELZUUR VERDUND 38%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 57%' WHERE FullName = 'ZWAVELZUUR VERDUND 57%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 58%' WHERE FullName = 'ZWAVELZUUR VERDUND 58%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 35%' WHERE FullName = 'ZWAVELZUUR VERDUND 35%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 76%' WHERE FullName = 'ZWAVELZUUR VERDUND 76%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 32%' WHERE FullName = 'ZWAVELZUUR VERDUND 32%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 36%' WHERE FullName = 'ZWAVELZUUR VERDUND 36%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 78%' WHERE FullName = 'ZWAVELZUUR VERDUND 78%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 50% ' WHERE FullName = 'ZWAVELZUUR VERDUND 50% trading';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 70% ' WHERE FullName = 'ZWAVELZUUR VERDUND 70% trading';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 78% ' WHERE FullName = 'ZWAVELZUUR VERDUND 78% trading';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 70%' WHERE FullName = 'ZWAVELZUUR VERDUND 70%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 24%' WHERE FullName = 'ZWAVELZUUR VERDUND 24%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 51%' WHERE FullName = 'ZWAVELZUUR VERDUND 51%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 37%' WHERE FullName = 'ZWAVELZUUR VERDUND 37%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 20%' WHERE FullName = 'ZWAVELZUUR VERDUND 20%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 50%' WHERE FullName = 'ZWAVELZUUR VERDUND 50%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 50% ' WHERE FullName = 'ZWAVELZUUR VERDUND 50% trading';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 65%' WHERE FullName = 'ZWAVELZUUR VERDUND 65%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 17%' WHERE FullName = 'ZWAVELZUUR VERDUND 17%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 30%' WHERE FullName = 'ZWAVELZUUR VERDUND 30%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 44%' WHERE FullName = 'ZWAVELZUUR VERDUND 44%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 37.50%' WHERE FullName = 'ZWAVELZUUR VERDUND 37,50%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 45% FOOD GRADE' WHERE FullName = 'ZWAVELZUUR VERDUND 45% FOOD GRADE';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 80%' WHERE FullName = 'ZWAVELZUUR VERDUND 80%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 40%' WHERE FullName = 'ZWAVELZUUR VERDUND 40%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 62%' WHERE FullName = 'ZWAVELZUUR VERDUND 62%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 60%' WHERE FullName = 'ZWAVELZUUR VERDUND 60%';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 50% FOOD GRADE' WHERE FullName = 'ZWAVELZUUR VERDUND 50% FOOD GRADE';
UPDATE ProductMaster SET ProductName = 'DILUTED SULFURIC ACID 67% FOOD GRADE' WHERE FullName = 'ZWAVELZUUR VERDUND 67% FOOD GRADE';
UPDATE ProductMaster SET ProductName = 'CHLOROSULFONIC ACID' WHERE FullName = 'CHLOORSULFONZUUR';
UPDATE ProductMaster SET ProductName = 'SULFURIC ACID 100.1% (PS3)' WHERE FullName = 'ZWAVELZUUR 100,1% (PS3)';
UPDATE ProductMaster SET ProductName = 'AMMONIUM BISULFITE TECHNICAL GRADE 70%' WHERE FullName = 'AMMONIUMBISULFIET TECHNICAL GRADE 70%';