金融其它商业智能
大家帮忙看看这个语句哪里出问题?
case
when [report].[XXCARD_STAT_2].[TYPE]='5' then
cast(_round([report].[XXCARD_STAT_2].[发卡量]*100,2),varchar(10))+'%'
else [report].[XXCARD_STAT_2].[发卡量]
end
cognos报错:语句中存在不兼容数据类型
发卡量字段中存的是带小数数字收起
when [report].[XXCARD_STAT_2].[TYPE]='5' then
cast(_round([report].[XXCARD_STAT_2].[发卡量]*100,2),varchar(10))+'%'
else [report].[XXCARD_STAT_2].[发卡量]
end
cognos报错:语句中存在不兼容数据类型
发卡量字段中存的是带小数数字收起
查看其它 9 个回答jeongspear的回答
我试过了~~
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
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
浏览635