{
    "error": "Errore durante la lettura dei dati:  WITH DATI AS (\nSELECT\nCAL.CAYEA,\nCAL.CAMON,\nT.DTTPD,\nT.DTCON,\nT.DTRAS,\nCOUNT(*) AS NUM_DOCUMENTI,\nSUM(T.DTIMP) AS TOTALE,\nAGE.CDAGE,\nAGE.AGRAS\nFROM sys_imp_ven T\nLEFT OUTER JOIN A01_AGE_NTI AGE ON AGE.CDAGE = T.DTAGE\nLEFT OUTER JOIN SYS_CAL CAL ON CAL.CADAT = T.DTDAT\nWHERE\nT.DTTPD IN ('OFF', 'ORD', 'FAT')\nAND (T.DTSTA IN ('CO','EV','PE','PC','CT') OR (T.DTTPD = 'OFF' AND T.DTSTA = 'PV'))\nAND DTANN >= YEAR(GETDATE()) - 2\nAND CHARINDEX(T.DTCAU, DBO.SYS_XFN_GET_CON_FIG('STA_CAU_DOC_ESCLUDI', '','')) = 0\nGROUP BY\nCAL.CAYEA,\nCAL.CAMON,\nT.DTTPD,\nT.DTCON,\nT.DTRAS,\nAGE.CDAGE,\nAGE.AGRAS\n),\nMAX_DATE AS (\nSELECT\nCAL.CAYEA,\nCAL.CAMON,\nT.DTTPD,\nT.DTCON,\nT.DTRAS,\nAGE.CDAGE,\nAGE.AGRAS,\nMAX(T.DTDAT) AS DATA_MAX\nFROM sys_imp_ven T\nLEFT OUTER JOIN A01_AGE_NTI AGE ON AGE.CDAGE = T.DTAGE\nLEFT OUTER JOIN SYS_CAL CAL ON CAL.CADAT = T.DTDAT\nWHERE\nT.DTTPD IN ('OFF', 'ORD', 'FAT')\nAND (T.DTSTA IN ('CO','EV','PE','PC','CT') OR (T.DTTPD = 'OFF' AND T.DTSTA = 'PV'))\nAND DTANN >= YEAR(GETDATE()) - 2\nAND CHARINDEX(T.DTCAU, DBO.SYS_XFN_GET_CON_FIG('STA_CAU_DOC_ESCLUDI', '','')) = 0\nGROUP BY\nCAL.CAYEA,\nCAL.CAMON,\nT.DTTPD,\nT.DTCON,\nT.DTRAS,\nAGE.CDAGE,\nAGE.AGRAS\n),\nPIVOT_TOTALE AS (\nSELECT\nCAYEA AS ANNO,\nCAMON AS MESE,\nISNULL(CDAGE, '') AS AGENTE,\nISNULL(AGRAS, '') AS RAG_AGENTE,\nDTCON,\nDTRAS,\n[OFF] AS TOTALE_OFF,\n[ORD] AS TOTALE_ORD,\n[FAT] AS TOTALE_FAT\nFROM (\nSELECT\nCAYEA, CAMON, CDAGE, AGRAS, DTCON, DTRAS, TOTALE, DTTPD\nFROM DATI\n) AS SRC\nPIVOT (\nSUM(TOTALE)\nFOR DTTPD IN ([OFF], [ORD], [FAT])\n) AS PVT_TOT\n),\nPIVOT_NUM_DOC AS (\nSELECT\nCAYEA AS ANNO,\nCAMON AS MESE,\nISNULL(CDAGE, '') AS AGENTE,\nDTCON,\nDTRAS,\n[OFF] AS NUM_OFF,\n[ORD] AS NUM_ORD,\n[FAT] AS NUM_FAT\nFROM (\nSELECT\nCAYEA, CAMON, CDAGE, DTCON, DTRAS, NUM_DOCUMENTI, DTTPD\nFROM DATI\n) AS SRC\nPIVOT (\nSUM(NUM_DOCUMENTI)\nFOR DTTPD IN ([OFF], [ORD], [FAT])\n) AS PVT_NUM\n)\nSELECT\n0 AS RECORD_ID,\nP.ANNO,\nP.MESE,\nP.AGENTE,\nP.RAG_AGENTE,\nP.DTCON AS CLIENTE,\nP.DTRAS AS RAG_SOCIALE,\nISNULL(N.NUM_OFF, 0) AS NUM_OFFERTE,\nISNULL(P.TOTALE_OFF, 0) AS OFFERTE,\nISNULL(CONVERT(VARCHAR, M.MAX_DATE_OFF, 103), '') AS ULTIMA_OFFERTA,\nISNULL(N.NUM_ORD, 0) AS NUM_ORDINI,\nISNULL(P.TOTALE_ORD, 0) AS ORDINI,\nISNULL(CONVERT(VARCHAR, M.MAX_DATE_ORD, 103), '') AS ULTIMO_ORDINE,\nISNULL(N.NUM_FAT, 0) AS NUM_FATTURE,\nISNULL(P.TOTALE_FAT, 0) AS FATTURE,\nISNULL(CONVERT(VARCHAR, M.MAX_DATE_FAT, 103), '') AS ULTIMA_FATTURA\nFROM PIVOT_TOTALE P\nJOIN PIVOT_NUM_DOC N\nON P.ANNO = N.ANNO\nAND P.MESE = N.MESE\nAND P.AGENTE = N.AGENTE\nAND P.DTCON = N.DTCON\nAND P.DTRAS = N.DTRAS\nLEFT JOIN (\nSELECT\nCAYEA AS ANNO,\nCAMON AS MESE,\nISNULL(CDAGE, '') AS AGENTE,\nDTCON,\nDTRAS,\nMAX(CASE WHEN DTTPD = 'OFF' THEN DATA_MAX END) AS MAX_DATE_OFF,\nMAX(CASE WHEN DTTPD = 'ORD' THEN DATA_MAX END) AS MAX_DATE_ORD,\nMAX(CASE WHEN DTTPD = 'FAT' THEN DATA_MAX END) AS MAX_DATE_FAT\nFROM MAX_DATE\nGROUP BY CAYEA, CAMON, CDAGE, DTCON, DTRAS\n) AS M\nON P.ANNO = M.ANNO\nAND P.MESE = M.MESE\nAND P.AGENTE = M.AGENTE\nAND P.DTCON = M.DTCON\nAND P.DTRAS = M.DTRASSQLSTATE[42S02]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid object name 'A01_AGE_NTI'."
}