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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-05 : 07:48:32
|
| Adam writes "I've created a view that has one column with several email addresses in it. I have a stored procedure that sends an email message, and I want to get each address in the column into a single string to use in the To field of the email. How do I do it?" |
|
|
SqlStar
Posting Yak Master
121 Posts |
Posted - 2003-09-05 : 08:05:09
|
| Adam,U can get that if u used any delimeters :-)":-) IT Knowledge is power :-)" |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-09-05 : 08:28:15
|
| [code]declare @to varchar(8000)select @to = coalesce(@to + ';','') + emailfrom adamstable[/code]Jay White{0} |
|
|
|
SqlStar
Posting Yak Master
121 Posts |
Posted - 2003-09-05 : 08:43:35
|
| Yeah. If he maintained some delimeters like ";" "," He can use your query easily.":-) IT Knowledge is power :-)" |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-09-05 : 09:35:13
|
| SqlStar, what do you mean by "maintained some delimeters"?Jay White{0} |
|
|
|
|
|
|
Getting emails from a table into a string