This is one I’ve been wanting to figure out for awhile and just never got around to it.
So you have a list like this:
Select email from emaillist
Returns:
email1 @ emailme.com
email2 @ emailme.com
email3 @ emailme.com
email4 @ emailme.com
email5 @ emailme.com
I get a record for each email in the table.
What I want is: email1 @ emailme.com,email2 @ emailme.com,email3 @ emailme.com,email4 @ emailme.com,email5 @ emailme.com,etc.
Here’s SQL I found to do it:
Declare @Description varchar(4000)
select @Description = coalesce(@Description + ‘,’ , ”) + rtrim(email) FROM emaillist
select @Description
You can change the ‘,’ to ‘;’ or any character you want for that matter.