800: Corresponding types must be compatible in CASE expression.
麻烦大家给我看看update t2
set df=(case when sample=0 and error <20 then mark *(1-cast(error/20.0 asdecimal(12,2)))
when sample>0 and rate <0.0001 then mark
when sample>0 and rate <=0.005 then mark*0.7
when sample>0 and rate <=0.01 then mark*0.3
else 0.0 end);
这个语句为什么会报错
800: Corresponding types must be compatible in CASE expression.
sample是整型，rate是decimal（12，4）类型的。
页:
[1]