Please keep in mind that this is a crummy solution and does not deal with Ordering...  I would suggest you make a new table with a correct design and let...

I have done this with Dynamic SQL when you do not know your number of columns.  As Jo points out, since you already know that information, I would highly recommend...

I knew what it was; that is why I corrected your spelling...  It is too cold up there for you'se guys - ain't it?   

Odd, that was a simple Google search, so there should be no cookie's required; worked for me... (Any way, my ability to post URL's with a mask is sushila's fault...

Here is a clunky, (bulldozer :pinch approach: 

CREATE TABLE #Email( EmailAddress varchar(10))

INSERT INTO #Email( EmailAddress)

SELECT ' 1'  UNION ALL

SELECT ' 2' ...

Why would you ever want to quit a job like that?    

I agree!  I think that is also what makes Cows Angry and Birds get upset stomachs!  [And my original degree was in science, so I can (pretend) I know what...

SELECT TOP 20 Post .postid, subject, name, replies, views, dt, flag, Reply.ReplyID,

                             Reply.Name, Reply.dt

FROM Post