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 Plain Text by registered user vvillacorta ( 5 years ago )
SELECT CASE WHEN
(SELECT MONTHS_BETWEEN(CAST(MIN( FECCARGA) AS DATE FORMAT 'YYYYMM'), CAST(PERIODO_PARAMETRO AS DATE FORMAT 'YYYYMM')) FROM E_DW_VIEWS.V_CONSOLIDADO_SUNAT_HIST WHERE FECCARGA>=PERIODO_PARAMETRO)
>=
(SELECT MONTHS_BETWEEN(CAST(PERIODO_PARAMETRO AS DATE FORMAT 'YYYYMM'), CAST(MAX( FECCARGA) AS DATE FORMAT 'YYYYMM')) FROM E_DW_VIEWS.V_CONSOLIDADO_SUNAT_HIST WHERE FECCARGA<=PERIODO_PARAMETRO)
OR (SELECT MIN( FECCARGA) FROM E_DW_VIEWS.V_CONSOLIDADO_SUNAT_HIST WHERE FECCARGA>=PERIODO_PARAMETRO) IS NULL
THEN
(SELECT MAX( FECCARGA) FROM E_DW_VIEWS.V_CONSOLIDADO_SUNAT_HIST WHERE FECCARGA<=PERIODO_PARAMETRO)
ELSE
(SELECT MIN( FECCARGA) FROM E_DW_VIEWS.V_CONSOLIDADO_SUNAT_HIST WHERE FECCARGA>=PERIODO_PARAMETRO)
END
Revise this Paste