Data for Report Services

Our developers approached me with this problem of formatting output for a
report. Hereâ's the record set
Store No SubDepartment
100 Clothes
200 Clothes
200 Shoes
200 Bunnies
The want to use SQL Syntax to return the following:
Store No SubDepartments
100 Clothes
200 Clothes, Shoes, Bunnies
Any suggestions? Thank you.Concatenating row values in Transact-SQL
http://www.projectdmx.com/tsql/rowconcatenate.aspx
AMB
"brymer28303" wrote:
> Our developers approached me with this problem of formatting output for a
> report. Hereâ's the record set
> Store No SubDepartment
> 100 Clothes
> 200 Clothes
> 200 Shoes
> 200 Bunnies
> The want to use SQL Syntax to return the following:
> Store No SubDepartments
> 100 Clothes
> 200 Clothes, Shoes, Bunnies
> Any suggestions? Thank you.
>