Combine Multiple records into one field

[dvannoy]

is it possible to combine multiple records into one record only ?

I'm trying to create a task list and would like to show the returned records in a asp.net list box.

so, below would be some records in separate rows.

Field1 06/02/15 Field2 Location 1

Field1 06/02/15 Field2 Location 2

Now, I would like to select the records based on the date of 06/02/15 and combine "Field2" from both rows into it's own Field. is this possible ?

any help would be appreciated.

Thanks

 

[TamarGranor]

Something like this:

SELECT Field1, 
       Stuff(SELECT "," + Field2 
         FROM YourTable YT2
         WHERE YT1.Field1 = YT2.Field1
         ORDER BY Field2 
         FOR XML PATH('')), 1, 2, '') Items
   FROM YourTable YT1
   GROUP BY Field1
   ORDER BY 1

For an explanation, see my article:

http://www.tomorrowssolutionsllc.com/Articles/Consolidate data from a field into a list.pdf

Tamar