sql:新开一列按某列数据显示含义(CASE WHEN)

select 
SourceProcessCode, 

/*

SourceProcessCode的值如下
Dec_EPOrder 订单  
Dec_EPLogistics 运单  
Dec_EPReceipt 收款  
Dec_EPInventory 清单 
Dec_EPWayBill 清总
Dec_EPDeparture 离境单
*/

-- 新增SourceProcessCode_name列显示代表的含义
CASE WHEN SourceProcessCode = 'Dec_EPOrder' THEN '订单'
WHEN SourceProcessCode = 'Dec_EPLogistics' THEN '运单'
WHEN SourceProcessCode = 'Dec_EPReceipt' THEN '收款'
WHEN SourceProcessCode = 'Dec_EPInventory' THEN '清单'
WHEN SourceProcessCode = 'Dec_EPWayBill' THEN '清总'
WHEN SourceProcessCode = 'Dec_EPDeparture' THEN '离境单'
ELSE '' END AS SourceProcessCode_name,
*
from Dec_OrderSub 
where 
OwnerCode='3502100082'  
-- and SourceProcessCode='Dec_EPInventory'
order by CreateDate asc