I have a the ff tables:

Users(UserID,Username)

Departments(DepartmentID,DepartmentName)

UserDepartments(UserID,DepartmentID)

I want to display the list of departments in a comma-separated fashion.
I tried using COALESCE,FOR XML PATH for these and Im having performance issues when the query returns lots of data.

Im using UDFs for coalesce. Could be the reason why Im hitting performance.

Is there any other way of doing it?

"Dont you ever give up!"

__________________
\"Dont you ever give up!\"

Try checking out the following link that returns a comma-delimited string without using a cursor and see if it will help you:

http://www.sql-server-helper.com/tip...ed-output.aspx

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp

Using Coalesce is faster than that.

I have 14 columns that are comma separated and calling UDFs for those columns I think is not an option.

Thank you anyway..

"Dont you ever give up!"

Got any test code that proves that?

--Jeff Moden