skij
asked on
MS SQL: Return all results in a single row separated by commas
This returns a 50 rows. Instead, using MS SQL, how can I get one single row with all 50 values separated by commas?
SELECT
TOP 50
NAME
FROM [my].[dbo].[table]
WHERE
PROJECTID = 699461
GROUP BY NAME
ORDER BY count(NAME) DESC
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.