SQL 累次EXISTS语句优化，求大神解答
SQL 多次EXISTS语句优化，求大神解答
SELECT YEAR(@ksrq) TBNF,MONTH(@ksrq) TBYF,ROW_NUMBER() OVER(ORDER BY A.XM) AS INO,B.DZBH DZBH,A.XM,
(SELECT DAXX FROM SYS1_DAZB WHERE DAZX='02' AND WTBH='0100' AND DABH=A.XB) XBDIS,
CONVERT(VARCHAR(10),A.CSRQ,120) CSRQDIS,B.FQXM FQXM,B.MQXM MQXM,A.HKDZ HKDZ,A.JZDZ JZDZ,
A.LXDH LXDH,A.LXRDH LXRDH,
(SELECT TOP 1 CONVERT(VARCHAR(10),JCRQ,120) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00') MYJCRQ,
(SELECT TOP 1 TZ FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00') MYTZ,
(SELECT TOP 1 SC FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00') MYSC,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=TZPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00' ORDER BY JCRQ DESC) MYTZPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=SCPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00' ORDER BY JCRQ DESC) MYSCPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=SCBTZPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00' ORDER BY JCRQ DESC) MYSCBTZPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0204' AND DABH=WYQK) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00' ORDER BY JCRQ DESC) MYWYQK,
(SELECT TOP 1 CONVERT(VARCHAR(10),JCRQ,120) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00') SYJCRQ,
(SELECT TOP 1 TZ FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00') SYTZ,
(SELECT TOP 1 SC FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00') SYSC,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=TZPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00' ORDER BY JCRQ DESC) SYTZPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=SCPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00' ORDER BY JCRQ DESC) SYSCPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=SCBTZPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00' ORDER BY JCRQ DESC) SYSCBTZPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0204' AND DABH=WYQK) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00' ORDER BY JCRQ DESC) SYWYQK,
(SELECT TOP 1 CONVERT(VARCHAR(10),JCRQ,120) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-04-01' AND SZNL<='0-07-00') LYJCRQ,
(SELECT TOP 1 TZ FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-04-01' AND SZNL<='0-07-00') LYTZ,
(SELECT TOP 1 SC FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-04-01' AND SZNL<='0-07-00') LYSC,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=TZPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-04-01' AND SZNL<='0-07-00' ORDER BY JCRQ DESC) LYTZPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=SCPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-04-01' AND SZNL<='0-07-00' ORDER BY JCRQ DESC) LYSCPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=SCBTZPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-04-01' AND SZNL<='0-07-00' ORDER BY JCRQ DESC) LYSCBTZPJ,
SELECT YEAR(@ksrq) TBNF,MONTH(@ksrq) TBYF,ROW_NUMBER() OVER(ORDER BY A.XM) AS INO,B.DZBH DZBH,A.XM,
(SELECT DAXX FROM SYS1_DAZB WHERE DAZX='02' AND WTBH='0100' AND DABH=A.XB) XBDIS,
CONVERT(VARCHAR(10),A.CSRQ,120) CSRQDIS,B.FQXM FQXM,B.MQXM MQXM,A.HKDZ HKDZ,A.JZDZ JZDZ,
A.LXDH LXDH,A.LXRDH LXRDH,
(SELECT TOP 1 CONVERT(VARCHAR(10),JCRQ,120) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00') MYJCRQ,
(SELECT TOP 1 TZ FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00') MYTZ,
(SELECT TOP 1 SC FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00') MYSC,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=TZPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00' ORDER BY JCRQ DESC) MYTZPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=SCPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00' ORDER BY JCRQ DESC) MYSCPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=SCBTZPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00' ORDER BY JCRQ DESC) MYSCBTZPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0204' AND DABH=WYQK) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-00-20' AND SZNL<='0-02-00' ORDER BY JCRQ DESC) MYWYQK,
(SELECT TOP 1 CONVERT(VARCHAR(10),JCRQ,120) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00') SYJCRQ,
(SELECT TOP 1 TZ FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00') SYTZ,
(SELECT TOP 1 SC FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00') SYSC,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=TZPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00' ORDER BY JCRQ DESC) SYTZPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=SCPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00' ORDER BY JCRQ DESC) SYSCPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=SCBTZPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00' ORDER BY JCRQ DESC) SYSCBTZPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0204' AND DABH=WYQK) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-02-01' AND SZNL<='0-04-00' ORDER BY JCRQ DESC) SYWYQK,
(SELECT TOP 1 CONVERT(VARCHAR(10),JCRQ,120) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-04-01' AND SZNL<='0-07-00') LYJCRQ,
(SELECT TOP 1 TZ FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-04-01' AND SZNL<='0-07-00') LYTZ,
(SELECT TOP 1 SC FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-04-01' AND SZNL<='0-07-00') LYSC,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=TZPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-04-01' AND SZNL<='0-07-00' ORDER BY JCRQ DESC) LYTZPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=SCPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-04-01' AND SZNL<='0-07-00' ORDER BY JCRQ DESC) LYSCPJ,
(SELECT TOP 1 (SELECT DAXX FROM SYS1_DAZB WHERE DAZX='95' AND WTBH='0206' AND DABH=SCBTZPJ) FROM EB_BJ_TGJC WHERE GRBJH=B.GRBJH AND JLZT='0' AND SZNL>='0-04-01' AND SZNL<='0-07-00' ORDER BY JCRQ DESC) LYSCBTZPJ,