Psst.. new poll here.
[email protected] web/email now available. Want one? Go here.
Cannot use outlook/hotmail/live here to register as they blocking our mail servers. #microsoftdeez
Obey the Epel!
Paste
Pasted as SQL by registered user vvillacorta ( 1 month ago )
UPDATE A SET A.REGISTRO = B.REGISTRO
--SELECT A.REGISTRO, B.REGISTRO, A.PERIODO, B.PERIODO, A.SEGMENTO_FINAL, B.SEGMENTO_FINAL
FROM ODS.HM_SEG_BPE A
INNER JOIN (
SELECT *
FROM ODS.HM_SEG_BPE_VERSION_OLD
WHERE PERIODO = (SELECT MAX(PERIODO) FROM ODS.HM_SEG_BPE_VERSION_OLD)
) B
ON A.CODUNICOCLI = B.CODUNICOCLI
WHERE A.PERIODO = (SELECT MAX(PERIODO) FROM ODS.HM_SEG_BPE)
Revise this Paste