22,209
社区成员
发帖
与我相关
我的任务
分享
UPDATE SPB SET LSJ=ISNULL(B.LSJ,0),HUIYTJ=ISNULL(B.HUIYTJ,0),cuxj=isnull(b.cuxj,0)
FROM SPB A JOIN TMP_SPB B ON B.BH=@ID AND A.DSPID=B.DSPID
UPDATE HWC SET LSJ=ISNULL(B.LSJ,0)
FROM HWC A JOIN TMP_SPB B ON B.BH=@ID AND A.DSPID=B.DSPID AND ISNULL(A.LSJ,0)<>0