Servers

by | Apr 6, 2011 | Photo - Computers, Photoblog

Servers

So, it’s been awhile since I’ve posted but I’m ready to get back into the swing. Especially since I got a new camera back in December and have not been using it. Maybe I need to go for the picture a day routine so I get myself in the mode to shoot and process more often.

Make comma seperated list out of records in SQL Server

by | Mar 29, 2011 | Blog, SQL Server

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.