Psst.. new poll here.
[email protected] webmail 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 ( 4 months ago )
CASE WHEN gestion_tipo IS NOT NULL AND gestion_tipo NOT LIKE '' THEN 1 ELSE 0 END FLG_GESTION_VPCONNECT,
CASE WHEN gestion_tipo IS NOT NULL AND gestion_tipo NOT LIKE '' AND gestion_tipo NOT LIKE '%Sin Contacto%' THEN 1 ELSE 0 END FLG_CE_VPCONNECT,
CASE WHEN gestion_tipo LIKE '%Acepta%' AND gestion_tipo NOT LIKE '%No%' AND gestion_tipo NOT LIKE '%Visita%' THEN 1 ELSE 0 END FLG_ACEPTA_VPCONNECT,
CASE WHEN gestion_tipo LIKE '%Acepta%' AND gestion_tipo LIKE '%No%' THEN 1 ELSE 0 END FLG_NO_ACEPTA_VPCONNECT,
CASE WHEN gestion_tipo LIKE '%Lo Pensa%' THEN 1 ELSE 0 END FLG_LO_PENSARA_VPCONNECT ,
CASE WHEN gestion_tipo = 'No Califica' THEN 1 ELSE 0 END FLG_NO_CALIFICA_VPCONNECT,
CASE WHEN gestion_tipo LIKE '%Desisti%' THEN 1 ELSE 0 END FLG_DEISTE_VPCONNECT,
Revise this Paste