select distinct cliente,
(SELECT TOP 1 CONSERJE                 from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  CONSERJE,
(SELECT TOP 1 GARAJE                   from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  GARAJE,
(SELECT TOP 1 ALARMA                   from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  ALARMA,
(SELECT TOP 1 CCTV                     from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  CCTV,
(SELECT TOP 1 PCIEXTINCION             from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PCIEXTINCION,
(SELECT TOP 1 PCIDETECCION             from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PCIDETECCION,
(SELECT TOP 1 MONOXIDO                 from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  MONOXIDO,
(SELECT TOP 1 ELECTRICIDAD             from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  ELECTRICIDAD,
(SELECT TOP 1 ANTENA                   from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  ANTENA,
(SELECT TOP 1 PORTERO                  from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PORTERO,
(SELECT TOP 1 VIDEOPORTERO             from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  VIDEOPORTERO,
(SELECT TOP 1 AIREACONDICIONADO        from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  AIREACONDICIONADO,
(SELECT TOP 1 CCTVDVR                  from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  CCTVDVR,
(SELECT TOP 1 CCTVDVRCAPACIDAD         from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  CCTVDVRCAPACIDAD,
(SELECT TOP 1 CCTVNCAMARASINTERIORES   from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  CCTVNCAMARASINTERIORES,
(SELECT TOP 1 CCTVNCAMARASEXTERIORES   from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  CCTVNCAMARASEXTERIORES,
(SELECT TOP 1 ALARMANCENTRAL           from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  ALARMANCENTRAL,
(SELECT TOP 1 ALARMAMODELO             from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  ALARMAMODELO,
(SELECT TOP 1 ALARMANDETECCTORES       from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  ALARMANDETECCTORES,
(SELECT TOP 1 ALARMANDETECTINT         from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  ALARMANDETECTINT,
(SELECT TOP 1 ALARMANDETECTEXT         from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  ALARMANDETECTEXT,
(SELECT TOP 1 PCIEXTINCNBIES           from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PCIEXTINCNBIES,
(SELECT TOP 1 PCIEXTINCGRUPOPRESION    from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PCIEXTINCGRUPOPRESION,
(SELECT TOP 1 PCIEXTINCCOLUMNASECA     from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PCIEXTINCCOLUMNASECA,
(SELECT TOP 1 PCIDETECNCENTRALES       from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PCIDETECNCENTRALES,
(SELECT TOP 1 PCIDETECNDETECTORES      from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PCIDETECNDETECTORES,
(SELECT TOP 1 PCIDETECNPULSADORES      from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PCIDETECNPULSADORES,
(SELECT TOP 1 PCIDETECNSIRENAS         from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PCIDETECNSIRENAS,
(SELECT TOP 1 PCIDETECNEMERGENCIAS     from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PCIDETECNEMERGENCIAS,
(SELECT TOP 1 MONOXIDONCENTRALES       from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  MONOXIDONCENTRALES,
(SELECT TOP 1 MONOXIDONDETECTORES      from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  MONOXIDONDETECTORES,
(SELECT TOP 1 MONOXIDONCUADROS         from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  MONOXIDONCUADROS,
(SELECT TOP 1 MONOXIDONMOTORES         from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  MONOXIDONMOTORES,
(SELECT TOP 1 PUERTASN                 from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PUERTASN,
(SELECT TOP 1 PUERTASTIPO1             from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PUERTASTIPO1,
(SELECT TOP 1 PUERTASTIPO2             from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  PUERTASTIPO2,
(SELECT TOP 1 NVIVIENDAS               from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  NVIVIENDAS,
(SELECT TOP 1 NANTENAS                 from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  NANTENAS,
(SELECT TOP 1 NEXITINTORES             from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  NEXITINTORES,
(SELECT TOP 1 TIPOCABECERA             from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  TIPOCABECERA,
(SELECT TOP 1 MARCA                    from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  MARCA,
(SELECT TOP 1 NEQUIPOSSECUNDARIOS      from rps.dbo.etl_inmuebles AS I where I.CLIENTE=B.CLIENTE) AS  NEQUIPOSSECUNDARIOS
  from rps.dbo.etl_inmuebles where cliente<>''