
SET @from_unit_code = 'xyz';
SET @to_unit_code = 'slslsfh';

UPDATE ShopArticle AS sa SET sa.ShopWAWIProductUnit_Code = @to_unit_code WHERE sa.ShopWAWIProductUnit_Code = @from_unit_code;

UPDATE ShopArticleItem AS sai SET sai.ShopWAWIProductUnit_Code = @to_unit_code WHERE sai.ShopWAWIProductUnit_Code = @from_unit_code;

UPDATE ShopWAWIProduct AS swp SET swp.ShopWAWIProductUnit_Code = @to_unit_code WHERE swp.ShopWAWIProductUnit_Code = @from_unit_code;

-- DELETE FROM ShopWAWIProductUnit WHERE ShopWAWIProductUnit_Code = @from_unit_code;