国产操操操丨国产狂喷水潮免费网站www丨人善交video高清丨国产口语对白老妇丨黄色一级视频网丨国产午夜无码视频在线观看丨秋霞午夜一区二区三区黄瓜视频丨久久亚洲精品中文字幕无码丨超碰97干丨黄色理论视频丨最新国产精品剧情在线ss丨尤物视频一区丨含羞草一区二区丨午夜精品久久久久久久久丨亚洲v欧美

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

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