如何在MSSQL中合并多行

Select T1.Id    , Stuff(        (        Select ', ' + T2.Address        From MyTable As T2        Where T2.Id = T1.Id        Order By T2.Address        For Xml Path(''), type        ).value('.', 'nvarchar(max)'), 1, 2, '') As AddressFrom MyTable As T1Group By T1.Id