Retrieving a specific column as comma separated values

Question

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

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

Mark Cowne One Orange Chip Points: 26986 More actions · Answer 1

SELECT d.EmployeeID,d.Name,d.Department,d.Manager,

STUFF(((SELECT ', '+e.EmailAddress AS "text()"

FROM EmployeeEmailAddresses e

WHERE e.EmployeeID=d.EmployeeID

ORDER BY e.EmailAddress

FOR XML PATH(''),TYPE).value('./text()[1]','VARCHAR(1000)')),1,2,'') AS EmailAddresses

FROM EmployeeDetails d

ORDER BY d.Name;

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

Kaptnik Valued Member Points: 56 More actions · Answer 2

Valued Member

Points: 56

September 5, 2011 at 4:40 am

Thanks Mark-101232!

Works like a charm!