sql 字段值字符转化

关注

原创最新推荐文章于 2026-04-24 16:36:30 发布 347 阅读 AI 写同款· GEO 优化 ›

【sql regexp 正则匹配多对多】 sql regexp 正则匹配多对多阅读详情

case when a.DiningPlan =1 then '早餐' when a.DiningPlan =2 then '午餐' when a.DiningPlan =3 then '晚餐' when a.DiningPlan =4 then '其他' end  ,

select b.ClaimNo, a.Department,a.Master,a.TreatTime,
case when a.DiningPlan =1 then '早餐' when a.DiningPlan =2 then '午餐' when a.DiningPlan =3 then '晚餐' when a.DiningPlan =4 then '其他' end  ,
a.OtherDiningPlan,
case when a.TreatType =1 then '商务招待' when a.TreatType =2 then '外事招待' when a.TreatType =3 then '其他公务招待' end  ,

a.Guest,a.TreatCause,a.TotalCost,a.DiningPlace,a.PeopleNumber,a.NBPeopleNumber,a.PerMoney,a.DrinksCost,a.SpecialNote
from dbo.ClaimChildTravel AS a LEFT OUTER JOIN  
ClaimApply  as   b  on a.FormID=b.FormID
	LEFT OUTER JOIN   
               bpmdb.dbo.BPMI_TOKENLAST AS c ON c.TaskID = b.TaskId 
			
				where c.TokenName='结束' and b.CostType=10   and b.Contents not like '%业务招待费%' and a.IsDel=0