Home Forums Article Discussions Article Discussions by Author Discuss content posted by Carl P. Anderson Concatenating Rows RE: Concatenating Rows

  • October 14, 2009 at 2:32 am

    #1065531

    SELECT STUFF((

    SELECT ', ' + name

    FROM dbo.FRUIT

    FOR XML PATH('')

    ), 1, 2, '');