34,837
社区成员




select '000-071-174-A' A,'Q7' B
into #t
union all select '000-093-056-A','A5'
union all select '000-093-056-A','D3'
union all select '000-093-056-A','Q7'
union all select '000-093-056-A','TT'
union all select '000-098-650', 'B6'
union all select '000-098-650', 'C6'
union all select '000-098-653', 'B6'
select A
,(select B+' ' from #t b where a.A=b.A for xml path(''))
as B
from #t a
group by A