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 )
IF OBJECT_ID('TMP_VMVP_BARRIDO_WITH_COD_SBS_V2','U') IS NOT NULL DROP TABLE TMP_VMVP_BARRIDO_WITH_COD_SBS_V2
SELECT
B.COD_MES PERIODO,
B.NUM_DOCUMENTO,
--CASE WHEN ISNULL(B.COD_UNICOCLIENTE, '.') IN ('.', '00000000000')
-- AND ISNULL(PERSONA.CODUNICOCLI, '.') NOT IN ('.', '00000000000') THEN PERSONA.CODUNICOCLI
-- ELSE B.COD_UNICOCLIENTE END COD_UNICO,
--PERSONA.CODSBS,
--PERSONA.TIPDOC,
--PERSONA.NOMBRE_COMPLETO,
--PERSONA.TIPPERSONA,
CASE WHEN DES_RESULTLLAMADA_ININ LIKE '%ACEPTA CAMPANA%' AND
DES_RESULTLLAMADA_ININ NOT LIKE '%NO%' THEN 1 ELSE 0 END FLG_AGENDA,
B.PROPENSION,
B.GRUPO_EJE,
B.TIPO_CARGA,
B.CANT_B,
B.CANT_AC,
B.CANT_G,
B.CANT_CE,
B.CANT_ET,
B.CONSENTIMIENTO,
B.DES_RESULTLLAMADA_ININ
INTO TMP_VMVP_BARRIDO_WITH_COD_SBS_V2
FROM ODS.HD_NBARRIDO_GESTION_ININ_VTA_BPE B
UPDATE TMP_VMVP_BARRIDO_WITH_COD_SBS_V2
SET DES_RESULTLLAMADA_ININ = 'ACEPTA CAMPANA - ENVIADO COFIDE (CE)'
WHERE DES_RESULTLLAMADA_ININ = 'ACEPTA CAMPANA – ENVIADO COFIDE (CE)'
Revise this Paste