SQL相除

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