Vertical to horizontal 1

[damipera]

Hi guys,

I have a table that looks like this:

fld1    fld2

111     apple
111     banana
111     grapes
222     melon
333     grapes
333     orange
.
.
.

and I want a recordset that looks like this:

111  apple, banana, grapes
222  melon
333  grapes, orange
.
.
.

Can you please give me some ideas of how I could achieve this?

Thanks.

 

[gmmastros]

http://sqlandme.com/2011/04/27/tsql-concatenate-rows-using-for-xml-path/

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[damipera]

hi gmmastros, that's exactly what i needed!

thanks