嫩草一区二区三区-午夜免费av-黄色三级三级三级三级-男人爱看的网站-青青视频免费-久久伊人在-免费成人91-一级免费黄色大片-亚洲yy-av片免费在线-亚洲成人第一

注意：當(dāng)前為視頻教學(xué),文本教學(xué)可在視頻下方查看！

persent2=case isnull((select count(1) from sdym033 where ym03302=ym00501),0) when 0 then 0 else cast((select count(1) from sdym033 where ym03302=ym00501 and isnull(ym03308,0)>=isnull(ym03306,0)) as decimal(18,6))/isnull((select count(1) from sdym033 where ym03302=ym00501),0)*100 end

加工單語句：

persent2=case isnull((select count(1) from sdym034 where ym03402=ym00601),0) when 0 then 0 else cast((select count(1) from sdym034 where ym03402=ym00601 and isnull(ym03406,0)>=isnull(ym03404,0)) as decimal(18,6))/isnull((select count(1) from sdym034 where ym03402=ym00601),0)*100 end

生產(chǎn)計(jì)劃語句：

persent2=case isnull((select count(1) from sdym033 where ym03302=ym00501),0) when 0 then 0 else cast(isnull((select count(1) from sdym033 where ym03302=ym00501 and isnull(ym03308,0)>=isnull(ym03306,0)),0)*(1.000000/(select count(1) from sdym033 where ym03302=ym00501))*100 +isnull((select sum(ym03308/ym03306) from sdym033 where ym03302=ym00501 and isnull(ym03308,0)<isnull(ym03306,0)),0)*(1.000000/(select count(1) from sdym033 where ym03302=ym00501))*100 as decimal(18,6)) end

加工單語句：

persent2=case isnull((select count(1) from sdym034 where ym03402=ym00601),0) when 0 then 0 else cast(isnull((select count(1) from sdym034 where ym03402=ym00601 and isnull(ym03406,0)>=isnull(ym03404,0)),0)*(1.000000/(select count(1) from sdym034 where ym03402=ym00601))*100 +isnull((select sum(ym03406/ym03404) from sdym034 where ym03402=ym00601 and isnull(ym03406,0)<isnull(ym03404,0)),0)*(1.000000/(select count(1) from sdym034 where ym03402=ym00601))*100 as decimal(18,6)) end