Link to home
Start Free TrialLog in
Avatar of skij
skijFlag for Canada

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

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Rich Weissler
Rich Weissler

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial