Link to home
Start Free TrialLog in
Avatar of MoreThanDoubled
MoreThanDoubled

asked on

SQL recordset with comma separated field

I need some help with a query. I am using SQL 2008 R2.

I have to query a table that consist of the following example data

Location    Order  Line_Number
ABC             3211       1
ABC          3211       2
ABC          3211       3      


How can i write a query that will return a single line with a comma separated field (see exaple below):
ABC           3211       1,2,3
SOLUTION
Avatar of mrfreshly
mrfreshly

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
ASKER CERTIFIED SOLUTION
Avatar of PortletPaul
PortletPaul
Flag of Australia image

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