The Abyss

The Abyss

My first thought when I saw this shot was bubbles rising up while descending into a deep dark ocean cave. Actually it was taken in a cave and there was water, I just wasn’t under the water but looking down into a waterfall that was lit up from below. :)

HuHot

  • Camera: iPhone 4
  • Taken: 7 April, 2011
  • Aperture: ƒ/2.8
  • Focal length: 3.85mm
  • ISO: 200
  • Shutter speed: 1/15s

Servers

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

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.

Categories

Archives