Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rsteph
Starting Member
3 Posts |
 Posted - 2009-11-12 : 12:49:55
|
| I've got a query that gets the name and address of all the people that attended a specified event (entered through a form in Access by the user). The results get passed to a spreadsheet. What I would like to do is, if two people with the same address appear in the list, I'd like to change the [Name] column to include both names (i.e. Fred and Jane), instead of having two rows, each with one of the names. Is there a way for me to do this in SQL within either a Function or Stored Procedure?Any help would be greatly appreciated.Thank you. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Combining Rows