对比移库单的派生单据是否有问题

--检查转储单
select KCRKD1_SJDH,SUM(KCRKD2_SSSL) KCRKD2_SSSL INTO #KCRKD FROM KCRKD1,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBH AND KCRKD1_SJDH LIKE '@A%' 
GROUP BY KCRKD1_SJDH
select KCCKD1_SJDH,SUM(KCCKD2_SL) KCCKD2_SL INTO #KCCKD FROM KCCKD1,KCCKD2 WHERE KCCKD1_LSBH=KCCKD2_LSBH AND KCCKD1_SJDH LIKE '@A%' 
GROUP BY KCCKD1_SJDH

SELECT  * FROM #KCRKD ,#KCCKD where KCCKD1_SJDH=KCRKD1_SJDH AND KCRKD2_SSSL<>KCCKD2_SL

---检查移库单
select KCRKD1_SJDH,SUM(KCRKD2_SSSL) KCRKD2_SSSL INTO #KCRKDY FROM KCRKD1,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBH AND KCRKD1_SJDH LIKE '@Y%' 
GROUP BY KCRKD1_SJDH
select KCCKD1_SJDH,SUM(KCCKD2_SL) KCCKD2_SL INTO #KCCKDY FROM KCCKD1,KCCKD2 WHERE KCCKD1_LSBH=KCCKD2_LSBH AND KCCKD1_SJDH LIKE '@Y%' 
GROUP BY KCCKD1_SJDH

SELECT  * FROM #KCRKDY ,#KCCKDY where KCCKD1_SJDH=KCRKD1_SJDH AND KCRKD2_SSSL<>KCCKD2_SL

 

SELECT  * FROM KCRKD2  WHERE KCRKD2_LSBH=5110027 AND KCRKD2_FLBH='0000000003'

UPDATE  KCRKD2 SET KCRKD2_SSSL=60,KCRKD2_FSSSL1=60,KCRKD2_FSSSL2=60,KCRKD2_FSSSL3=60 WHERE KCRKD2_LSBH=5110027 AND KCRKD2_FLBH='0000000007'