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 .................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 .................V_CONSOLIDADO_SUNAT_HIST WHERE FECCARGA<=PERIODO_PARAMETRO)
OR (SELECT MIN( FECCARGA) FROM .................V_CONSOLIDADO_SUNAT_HIST WHERE FECCARGA>=PERIODO_PARAMETRO) IS NULL
THEN
(SELECT MAX( FECCARGA) FROM .................V_CONSOLIDADO_SUNAT_HIST WHERE FECCARGA<=PERIODO_PARAMETRO)
ELSE
(SELECT MIN( FECCARGA) FROM .................V_CONSOLIDADO_SUNAT_HIST WHERE FECCARGA>=PERIODO_PARAMETRO)
END
Revise this Paste