[resolvido] Sql server - Como remover o último caracteres dessa consulta

Usa STUFF. Exemplo:

select 
       t1.grupo, 
       stuff((select ',' + cast(t2.campo as varchar(10)) from tabela t2 where t2.grupo = t1.grupo for xml path ('')), 1, 1, '')
    from
       tabela t1
    group by
       t1.grupo

https://docs.microsoft.com/pt-br/sql/t-sql/functions/stuff-transact-sql

resolvi dessa forma.

Select
MAS_DOMICILIO.MICROAREA_ID,
Left(Coalesce((Select Cast(D.DOM_IDENTIFICACAO As VARCHAR(10)) + ‘,’ As [text()] From MAS_DOMICILIO As D Where MAS_DOMICILIO.MICROAREA_ID = D.MICROAREA_ID Order By D.DOM_IDENTIFICACAO For Xml Path(’’), Type).value(’.[1]’, ‘VARCHAR(MAX)’), ‘’), Len(Coalesce((Select Cast(D.DOM_IDENTIFICACAO As VARCHAR(10)) + ‘,’ As [text()] From MAS_DOMICILIO As D Where MAS_DOMICILIO.MICROAREA_ID = D.MICROAREA_ID Order By D.DOM_IDENTIFICACAO For Xml Path(’’), Type).value(’.[1]’, ‘VARCHAR(MAX)’), ‘’)) - 1) As LISTA_IDENTIFICADOR
From
MAS_DOMICILIO
Group By
MAS_DOMICILIO.MICROAREA_ID