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 |
|
jimmy2090
Starting Member
26 Posts |
 Posted - 2014-10-29 : 07:04:03
|
| Hi all,i have a list of data as below:Company EmailA AAA@abc.comA BBB@abc.comB xxx@def.comi would like to write a query to list out as below where select the company AAAA@abc.com, BBB@abc.com, ... |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-10-29 : 07:16:59
|
| Declare @stremail varchar(max)select @stremail =coalesce(stremail+',','')+email from yourtableselect @stremailJaveed Ahmedhttps://www.linkedin.com/pub/javeed-ahmed/25/5b/95 |
 |
|
|
jimmy2090
Starting Member
26 Posts |
Posted - 2014-10-29 : 07:29:16
|
| thank, it solved. |
|
|
|
|
|
|
Select list split by comma