migracion clientes direccion

SELECT TOP 100 IDCLIENTEUBICACION, IDCLIENTE,
(SELECT JerarquiaId FROM JerarquiaGeograficaId_TEMP WHERE ExternoId = IDCIUDAD) AS JerarquiaGeograficaId,
0 as JerarquiaOrganizacionalId,
IDTIPOUBICACION, CALLEPRINCIPAL,
CASE WHEN IFCALLEPRINCIPALVERIFICADA IS NULL THEN 0 ELSE IFCALLEPRINCIPALVERIFICADA END AS IFCALLEPRINCIPALVERIFICADA,
NUMERACION, CALLESECUNDARIA,
CASE WHEN IFCALLESECUNDARIAVERIFICADA IS NULL THEN 0 ELSE IFCALLESECUNDARIAVERIFICADA END AS IFCALLESECUNDARIAVERIFICADA,
BARRIO, REFDIRECCION, POSICION, 1 AS EsHabilitado, 0 AS Eliminado,
CASE WHEN REGISTRATIONDATE IS NULL THEN DATELASTUPDATE ELSE REGISTRATIONDATE END AS REGISTRATIONDATE,
REGISTRATIONIDUSER, DATELASTUPDATE, IDUSERLASTUPDATE FROM [Merge.PhuyuSalud].dbo.TBL_SERVICIOS_CLIENTES_UBICACION
WHERE IDCIUDAD != 0