여러행을 한로우에

select ProjectName, 
STUFF((
SELECT ', ' + u.UserName + '(' + cd.CodeName + ')'
FROM tbProjectManPower mp
LEFT OUTER JOIN vwUser u on mp.UserID = u.UserID and u.LanguageCode='ko-KR'
LEFT OUTER JOIN tbSYSCode cd on cd.MainCode='PROJECT.Position' and mp.ProjectPosition = cd.SubCode
WHERE mp.ProjectSeq = p.ProjectSeq 
FOR XML PATH('')
),1,1,'') AS UserName 
from tbProjectInfo p
where p.ProjectSeq = 3