case when (a.Salecount1+a.Salecount2+a.Salecount3+a.Salecount4)<>0
then convert(decimal(9,2),
sum(b.Salecount1+b.Salecount2+b.Salecount3+b.Salecount4)
/sum(a.Salecount1+a.Salecount2+a.Salecount3+a.Salecount4))
else 0
end as Salecount
这样写效率很低吗
then convert(decimal(9,2),
sum(b.Salecount1+b.Salecount2+b.Salecount3+b.Salecount4)
/sum(a.Salecount1+a.Salecount2+a.Salecount3+a.Salecount4))
else 0
end as Salecount
这样写效率很低吗
then convert(decimal(9,2),
sum(b.Salecount1+b.Salecount2+b.Salecount3+b.Salecount4)
/sum(a.Salecount1+a.Salecount2+a.Salecount3+a.Salecount4))
else 0
end as Salecount
把你的SQL语句贴完整。除0判断是没错,我是感觉你的语句有语法错误。