补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
本文来自博客园,作者:CelonY,转载请注明原文链接:https://www.cnblogs.com/CelonY/articles/18202374
浙公网安备 33010602011771号