[ms sql] 레코드 그룹별 문자열 합치기

SELECT DISTINCT mID, --동일한 그룹(FK)
       STUFF((
            SELECT ',' + PartName
            FROM   MemberPart
            WHERE  mID = A.mID --동일한 그룹(FK)				
			ORDER BY Number
            FOR XML PATH('')
       ),1,1,'') AS PartNameString
FROM   MemberPart AS A