Stored procedure: Return column values as comma separated values

Asked Dec 20 '12 at 11:32

Active Dec 20 '12 at 11:32

Viewed 111 times

Possible Duplicate:
Convert multiple rows into one with comma as separator

So i have this model, picture of my db model

and i want to create a stored procedure that, given a calendarEvent id, it returns the usernames of all domainusers attending to it in a comma separated string.

I can get the affected usernames in a table form easily with a join, but how do i kinda flatten that table?

edited May 23 '17 at 11:52

Community

asked Dec 20 '12 at 11:32

sergio

1,026
2
19
43

I think i can get to my solution with the question you linked – sergio Dec 20 '12 at 11:56
You can also use the STUFF command: http://stackoverflow.com/questions/4713476/how-to-get-csv-value-for-following-scenario – twoleggedhorse Dec 20 '12 at 21:58

Stored procedure: Return column values as comma separated values

0 Answers0