22,210
社区成员
发帖
与我相关
我的任务
分享
Update A
set [n2] = case when (select sum(nQty) from tabTempDDD where cMateNo=A.cMateNo and i<=A.id) <= isnull(B.nQty,0)
then A.nQty
else
case when isnull((select sum(nQty) from tabTempDDD where cMateNo=A.cMateNo and i<A.id),0) >=isnull(B.nQty,0)
then 0
else isnull(B.nQty,0)-isnull((select sum(nQty) from tabTempDDD where cMateNo=A.cMateNo and i<A.id),0)
end
end
from tabTempDDD A
left join tabTempDDD2 B
on A.cMateNo=B.cMateNo