troubleshooting Question

getting comma separated values as a column of a query

Avatar of visrah
visrah asked on
Microsoft SQL Server
3 Comments1 Solution757 ViewsLast Modified:
I need to get comma separated values of a column in an sql query as given in example below...consider we have two tables citytable and areatable..where ref col is city_code...
============================
select city.city_code,  (SELECT @AreaCodes = COALESCE(@AreaCodes + ';', '') +
area.area_code FROM areatable area where area.city_code = city.city_code)
from citytable city
where city.city_size > '100'
============================
NOTE: - consider city.city_siae in sqkm
i am getting an error like "Incorrect syntax near '='." ....i want above query to return the results like below

CITY                           AREA CODE
============================
AAAA                        11,22,33,44
BBBB                          55,66,77,88

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros