I have a SQL Server table of short (nvarchar 75) answers filed using a code to group them by. I'm wanting to run a query that will return all answers given for a specific code separated by a comma.
Query returns for group 100:
Apple, Orange, Pear
I've used FOR XML PATH in the past but was hoping to find a different approach. Thanks,