(case when a.kz_zzc = 0.0000 then 0 ELSE cast(cast(a.kz_zqsz/a.kz_zzc*100 as decimal(18,2)) as varchar(8)) end) as kz_ccbl
我先转成varchar类型,这步已经出错了。cast(a.kz_zqsz/a.kz_zzc*100 as decimal(18,2))这步是对的
我先转成varchar类型,这步已经出错了。cast(a.kz_zqsz/a.kz_zzc*100 as decimal(18,2))这步是对的
declare @i numeric(10,1)
set @i = '0.5'
select @i
select cast(@i*100 as varchar(10))+'%'
(case when a.kz_zzc = 0 then '0' ELSE str(a.kz_zqsz/a.kz_zzc*100, 10, 2) end)
cast(cast(a.kz_zqsz/a.kz_zzc*100 as decimal(18,2)) as varchar(8)) end)
+'%'
as kz_ccbl必须转换为VARCHAR类型。。