有条SQL如下:
select Distinct WorkPhase '制程', ModelNo '机种', BoardOfFiner '检验总数', BoardOfBad '不良数', (BoardOfFiner * CheckNum) '检验总点数',BCheckNadd '不良点数',Cast((BoardOfBad * 100.00/BoardOfFiner) as decimal(10,2 )) '不良率(%)',Cast(100-(BoardOfBad * 100.00/BoardOfFiner) as decimal(10,2 )) '直通率(%)',Cast(BCheckNadd * 1000000/(BoardOfFiner * CheckNum) as decimal(10,2)) 'DPPM' from tmp_ResultOfRate where WorkPhase <> 'PCK' Group by WorkPhase,ModelNo,BoardOfFiner,BoardOfBad,CheckNum,BCheckNadd select Distinct WorkPhase '制程', Mode
select Distinct WorkPhase '制程', ModelNo '机种', BoardOfFiner '检验总数', BoardOfBad '不良数', (BoardOfFiner * CheckNum) '检验总点数',BCheckNadd '不良点数',Cast((BoardOfBad * 100.00/BoardOfFiner) as decimal(10,2 )) '不良率(%)',Cast(100-(BoardOfBad * 100.00/BoardOfFiner) as decimal(10,2 )) '直通率(%)',Cast(BCheckNadd * 1000000/(BoardOfFiner * CheckNum) as decimal(10,2)) 'DPPM' from tmp_ResultOfRate where WorkPhase <> 'PCK' Group by WorkPhase,ModelNo,BoardOfFiner,BoardOfBad,CheckNum,BCheckNadd select Distinct WorkPhase '制程', Mode