34,590
社区成员
发帖
与我相关
我的任务
分享
UPDATE a SET a.ndhsl=CASE
WHEN a.ndhsl>a.ntpbzl and a.ntpbzl>b.sl-a.ndhsl+(a.ndhsl%a.ntpbzl)
THEN (SELECT b.sl FROM #15 b WHERE a.sspbh=b.sspbh)
WHEN ndhsl>ntpbzl AND ntpbzl<b.sl-ndhsl+(a.ndhsl%a.ntpbzl)
THEN (CONVERT(int,ndhsl/ntpbzl)*a.ntpbzl+a.ntpbzl)
WHEN ndhsl<ntpbzl AND ntpbzl>b.sl
THEN (SELECT a.sl FROM #15 a WHERE a.sspbh=sspbh)
WHEN ndhsl<ntpbzl AND ntpbzl<b.sl
THEN ntpbzl END FROM #12 a,#15 b
WHERE a.px=1 AND a.sspbh=b.sspbh