24 February 2015

Combining Multiple Rows Into A Single Row With A Common Column Value

Sample:

Harold    ASP.NET
Harold    C#
Harold    LINQ


SELECT X.myName,
   (SELECT ' ,  ' + Y.ProgrammingLanguage
    FROM myTable Y
    WHERE Y.myName = X.myName
    FOR XML PATH('')) [SECTORS/USERS]
FROM myTable X
GROUP BY X.myName
ORDER BY 1



Result:

Harold    ASP.NET, C#, LINQ

No comments:

Post a Comment