处理收货地址

select * from ZWDWJHZD

---检查销售订单地址是否有错误
select XSDD_DHDD,XSDD_DDBH,XSDD_C10,ZWDWJHZD_JHDD from XSDD,ZWDWJHZD WHERE XSDD_DZBH_ID IS NOT NULL AND LEN(XSDD_DHDD)>8 
 and XSDD_DZBH_ID=ZWDWJHZD_C1 and XSDD_DHDD<>ZWDWJHZD_JHDD

 ---检查是否有遗漏地址未同步
 select XSDD_DHDD,XSDD_DDBH,XSDD_C10
 from  XSDD WHERE XSDD_DZBH_ID IS NOT NULL and XSDD_DZBH_ID not in(select  ZWDWJHZD_C1 from ZWDWJHZD)
 
 --更新销售订单地址
update XSDD set XSDD_DHDD=ZWDWJHZD.ZWDWJHZD_JHDD from XSDD,ZWDWJHZD WHERE XSDD_DZBH_ID IS NOT NULL  
 and XSDD_DZBH_ID=ZWDWJHZD_C1 AND XSDD_DHDD<>ZWDWJHZD_JHDD

 SELECT  XSDD_DDBH,XSDD_DHDD,ZWDWJHZD_JHDD from XSDD,ZWDWJHZD WHERE XSDD_DZBH_ID IS NOT NULL  
 and XSDD_DZBH_ID=ZWDWJHZD_C1 AND XSDD_DHDD<>ZWDWJHZD_JHDD


 SELECT XSTDMX_DDLS,XSTD_TDLS, XSTD_DHDD,XSTDMX_DDBH,XSTD_TDBH,XSTD_C1 INTO #XSTD FROM  XSTD,XSTDMX 
 WHERE XSTD.XSTD_TDLS=XSTDMX.XSTDMX_TDLS 

 UPDATE  #XSTD SET XSTD_C1=XSDD_DHDD FROM XSDD WHERE XSDD_DDLS=XSTDMX_DDLS

 SELECT  * FROM  #XSTD WHERE XSTD_DHDD<>XSTD_C1

 select A.XSTD_DHDD,B.XSTD_C1 from XSTD A,#XSTD B WHERE A.XSTD_TDLS=B.XSTD_TDLS AND A.XSTD_DHDD<>B.XSTD_C1
  AND XSTD_YWRQ>'20240101' AND XSTDMX_DDBH  LIKE 'SO%'
  --更新销售提单地址
  UPDATE XSTD SET XSTD_DHDD=B.XSTD_C1  from XSTD A,#XSTD B WHERE A.XSTD_TDLS=B.XSTD_TDLS AND A.XSTD_DHDD<>B.XSTD_C1
  AND XSTDMX_DDBH  LIKE 'SO%'