March 7, 2013 at 10:55 am
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
March 7, 2013 at 3:37 pm
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