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 |
|
joemama
Posting Yak Master
113 Posts |
 Posted - 2011-01-02 : 15:30:56
|
| i have a query that collects email address in rowsSELECT useremailFROM dbo.WQryNewsletterlike thisxxx@gmail.comyyy@gmail.comzzz@gmail.combut i want it to return it like thisxxx@gmail.com,yyy@gmail.com,zzz@gmail.comcan someone tell me how to do it? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-01-02 : 16:20:21
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
Query to return all rows to one row