select [PI],Model,Line as '产线', sum(Pass) as '好机数',sum(Fail) as '坏机数', sum(Pass+Fail) as '合计',
ltrim(cast(convert(float,sum(Fail))/sum(Pass+Fail)*100 as decimal(18,2)))+'%' as '坏机率' from [MesCount]
where [WorkDate]>'2012-7-21'
GROUP BY [PI],Model,Line ,WorkTime
分子总是带有小数点,否则结果总是为0%
如:
select convert(float,10)/20--------0.5
select 10/20--------------------------0