销售项目和产品对应错误处理脚本

CREATE TABLE TCPYY_CPCW_20191129 AS SELECT * FROM TCPYY WHERE CPID =36335;

CREATE TABLE TZJJZ_CPCW_20191129 AS SELECT * FROM TZJJZ WHERE CPYYID IN (SELECT ID FROM TCPYY WHERE CPID =36335);

SELECT * FROM TFP_CPSYJB WHERE CPID =36335–错误 A–38613 B-38614

SELECT * FROM TFP_CPSYJB WHERE CPID =36333–正确 A–38612 B-38611

UPDATE TCPYY C SET CPID=36333,XSXM= 3333,SYJB=(CASE WHEN C.SYJB=38613 THEN 38612 WHEN C.SYJB=38614 THEN 38611 END )/,CPQX/ WHERE CPID =36335;

delete FROM TZJJZ WHERE CPYYID IN (SELECT ID FROM TCPYY WHERE CPID =36333);

COMMIT;