Coalesce question?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Coalesce question?

Coalesce question?

Rate Topic

Display Mode

Topic Options

Author

Message

ahelbling33

Posted Thursday, March 07, 2013 10:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 07, 2013 11:08 AM
Points: 1, Visits: 2

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

Post #1428143

Erin Ramsay

Posted Thursday, March 07, 2013 3:37 PM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:46 AM
Points: 421, Visits: 777

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

Post #1428304

« Prev Topic | Next Topic »

Permissions