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 ( 1 year ago )
DELETE FROM ods.HM_SEG_BPE WHERE periodo_campania = (SELECT MAX(periodo_campania) FROM DBO.TMP_OBM_SEG_BPE)
insert into ods.HM_SEG_BPE
SELECT periodo_ejecucion,
CAST(GETDATE() AS DATE)
,nro_doc
,cuc_num
,venta_declarada
,promedio_saldo_promedio_pasivo_u6m
,segmento_final
,REGISTRO_FINAL
,PRIORIDAD_ATENCION
,cartera_dsc
,grupo
,saldo_promedio_activo
,deuda_rcc_u12m
,promedio_saldo_promedio_pasivo_u3m
,promedio_ingreso_total_final_u3m
,promedio_montototal_soles_izipay_u6m
,flg_adex_u6m
,clas_riego_sbs_dsc
,banca_final_dsc
,percentil_rentabilidad
,comb_final_potencialidad
,segmento_final_sin_filtros
,filtros_negocio
,flg_nuevo
,periodo_campania
,flg_cart_base
,registro_vpc_cliente
,registro_sda
FROM DBO.TMP_OBM_SEG_BPE
WHERE periodo_campania = (SELECT MAX(periodo_campania) FROM DBO.TMP_OBM_SEG_BPE)
Revise this Paste