Province = CASE WHEN DCCity = '商丘' THEN '河南' WHEN DCCity <> '商丘' THEN '非河南' END,
case ISNeed when '1' then '10' when '0' then '20' end as TotalFreight
Province = CASE WHEN DCCity = '商丘' THEN '河南' WHEN DCCity <> '商丘' THEN '非河南' END,
case ISNeed when '1' then '10' when '0' then '20' end as TotalFreight
转载于:https://www.cnblogs.com/ZkbFighting/p/11451133.html