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
Thanks for using Experts Exchange.
Please provide your email to receive a sample view!
*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.