亚洲精品一区二区三区在线观看-av网站免费看-久久久久伊人-91免费小视频-亚洲国产综合在线-潘金莲一级淫片aaaaa-麻豆伊人-国产宾馆自拍-精品成人国产-欧美一二三在线-男女裸体影院高潮-美女扒开下面让男人捅-国产一区二区福利视频-av成人福利-真实av在线

注意：當前為視頻教學,文本教學可在視頻下方查看！

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

生產計劃語句：

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