我试过了~~casewhen [report].[XXCARD_STAT_2].[TYPE]='5' then cast([report].[XXCARD_STAT_2].[发卡量]*100 as decimal(10,2)) else [report].[XXCARD_STAT_2].[发卡量]end上面没有语法错误,再加一层cast 就报错:语句中存在不兼容数据类型(代码如下)casewhen [report].[X...
显示全部我试过了~~
case
when [report].[XXCARD_STAT_2].[TYPE]='5' then
cast([report].[XXCARD_STAT_2].[发卡量]*100 as decimal(10,2))
else [report].[XXCARD_STAT_2].[发卡量]
end
上面没有语法错误,再加一层cast 就报错:语句中存在不兼容数据类型(代码如下)
case
when [report].[XXCARD_STAT_2].[TYPE]='5' then
cast(cast([report].[XXCARD_STAT_2].[发卡量]*100 as decimal(10,2)) as varchar(20))
else [report].[XXCARD_STAT_2].[发卡量]
end
收起