那些要转的,原先是什么类型?试试这样:select area,ys,hd,sum(convert(float,isnull(Ljsr,0)))-sum(convert(float,isnull(LjQpSr,0))) as LjSr, sum(convert(float,isnull(DrSr,0)))-sum(convert(float,isnull(DrQpSr,0))) as DrSr from ffTempSr group by area, ys,hd
调试欢乐多
select area,ys,hd,sum(isnull(convert(float,Ljsr),0))-sum(isnull(convert(float,LjQpSr),0)) as LjSr, sum(isnull(convert(float,DrSr),0))-sum(isnull(convert(float,DrQpSr),0)) as DrSr from ffTempSr group by area, ys,hd