esta es mi consulta
Código SQL:
Ver originalSELECT C.CAPITULO, C.PARTIDA,IDTIPNOM, UNIRES, GBL.TRACVE,C.CONCEPTO_DESC, GBL.TRADAT, SUM(TRAIMP)IMPORTE,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((REPLACE(GBL.TRADAT , 0,'')),1,''),2,''),3,''),4,''),5,''),6,''),7,''),8,''),9,'') dato
FROM CONCEPTOS C JOIN GBL2013 GBL ON C.TRACVE = GBL.TRACVE
WHERE TRATIP LIKE '1'
AND QNAPROC IN (23 ,24 )
AND IDTIPNOM LIKE '1'
AND UNIRES LIKE '416'
AND REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((REPLACE(GBL.TRADAT , 0,'')),1,''),2,''),3,''),4,''),5,''),6,''),7,''),8,''),9,'') = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((REPLACE(C.TRADAT , 0,'')),1,''),2,''),3,''),4,''),5,''),6,''),7,''),8,''),9,'')
GROUP BY IDTIPNOM, UNIRES, GBL.TRACVE, GBL.TRADAT,C.CONCEPTO_DESC,C.TRACVE,C.CAPITULO,C.PARTIDA
Lo que busco esque me muestre esta consulta repetidas veces por mes de manera acumulada.