Coalesce question?

  • I am trying to concatenate the URL column into one csv value for each ApplicantID. I am not having luck achieving the results I am looking for. Any help most appreciated...

    SELECT

    FASTFacultyApps.LastName,

    COALESCE([FacultyApps_TEST].[dbo].[VideoLinks].URL + ',', '') + [FacultyApps_TEST].[dbo].[VideoLinks].URL AS VidList

    FROM

    [FacultyApps_TEST].[dbo].FASTFacultyApps

    JOIN

    [FacultyApps_TEST].[dbo].[VideoLinks]

    ON

    [FacultyApps_TEST].[dbo].[VideoLinks].ApplicantID = [FacultyApps_TEST].[dbo].FASTFacultyApps.ID

    WHERE

    [FacultyApps_TEST].[dbo].FASTFacultyApps.isArchived = 0

    RESULT:

    TABLES:

    TIA,

    Andrew

  • I applied some quick GoogleFu to find this for you.. there are many examples of what you want out there.

    http://www.kodyaz.com/articles/concatenate-using-xml-path.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply