Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so dont bother with any of their useless mail servers here and just use oauth login instead. Thank the nice Russians for causing that. :)
Paste
Pasted as SQL by registered user vvillacorta ( 4 years ago )
SELECT A.FECPROCESO, TRIM(A.CODDOC) NUMRUC,
SUM(MONTODEUDA) monto_deuda_tributo_amt,
MIN(FECINICIOPROCESO) FECINICIOPROCESOTRIBUTO,
CASE WHEN MAX(FECINICIOPROCESO) IS NULL THEN 0
ELSE MONTHS_BETWEEN(CAST(FECPROCESO AS DATE FORMAT 'YYYYMM'),CAST(MIN(FECINICIOPROCESO) AS DATE FORMAT 'YYYYMM')) / 12
END tiempo_deuda_tributaria_amt,
CASE WHEN SUM(MONTODEUDA) = 0 THEN 0 ELSE COUNT(CODDOC) END cnt_deudas_tributarias
FROM .....................V_TRIBUTOS_SUNAT_HIST A
WHERE 1 = 1
AND ESTADO = 0
GROUP BY A.FECPROCESO, TRIM(A.CODDOC)
Revise this Paste