跨多列使用多个条件时用大小写

Question

举个简单的例子：

​

​

我需要将UnitsofMeterRemoved列中的“帝国”改为“米制”。然而，当米模型= g4和MeterManufacturerRemoved = KROMSCHRODER时，必须这样做。

我试过这个

SELECT *,
CASE WHEN MeterModelRemoved = 'G4'
    AND MeterManufacturerRemoved = 'KROMSCHRODER'
    AND UnitsofMeterRemoved = 'Imperial'
    THEN UnitsofMeterRemoved = 'Metric'
    END AS MeterModelRemoved
FROM CTE_2

但帝国帝国还在出现吗？知道为什么会发生这种事吗？

Answer 1

在下面使用

SELECT * EXCEPT(UnitsofMeterRemoved),
  CASE WHEN MeterModelRemoved = 'G4'
    AND MeterManufacturerRemoved = 'KROMSCHRODER'
    AND UnitsofMeterRemoved = 'Imperial'
  THEN 'Metric'
  ELSE UnitsofMeterRemoved
  END AS UnitsofMeterRemoved
FROM CTE_2