补PDA没有反写入库数量成功的情况

SELECT CGDHD2_SSSL, CGDHD2_RKSL,CGDHD2_THSL,KCRKD2_SSSL,  * FROM  CGDHD2 ,
(select KCRKD2_DHLS,KCRKD2_DHFL,KCRKD2_WLBH,sum(KCRKD2_SSSL) KCRKD2_SSSL from  KCRKD2
 where ISNULL(KCRKD2_DHLS,'')<>'' AND KCRKD2_SSSL>0
group by KCRKD2_DHLS,KCRKD2_DHFL,KCRKD2_WLBH) b
WHERE CGDHD2_LSBH=KCRKD2_DHLS AND CGDHD2_FLBH=KCRKD2_DHFL
AND CGDHD2_RKSL<>KCRKD2_SSSL

UPDATE  CGDHD2 SET CGDHD2_RKSL=b.KCRKD2_SSSL,CGDHD2_FRKSL1=b.KCRKD2_SSSL,CGDHD2_FRKSL2=KCRKD2_SSSL
  FROM  CGDHD2 ,
(select KCRKD2_DHLS,KCRKD2_DHFL,KCRKD2_WLBH,sum(KCRKD2_SSSL) KCRKD2_SSSL from  KCRKD2
 where ISNULL(KCRKD2_DHLS,'')<>'' AND KCRKD2_SSSL>0 
group by KCRKD2_DHLS,KCRKD2_DHFL,KCRKD2_WLBH) b
WHERE CGDHD2_LSBH=KCRKD2_DHLS AND CGDHD2_FLBH=KCRKD2_DHFL
AND CGDHD2_RKSL<>KCRKD2_SSSL 

 

posted @ 2024-05-20 16:53  CelonY  阅读(5)  评论(0)    收藏  举报