ONe more question? I loaded this into a stored procedure and noticed that it drops my drop statements (even if table exists drop statments)

First, you guys rock! Thank you very much... Here is what it ended up being.

INSERT INTO #MyQuestions (DynamicID)

 SELECT dynamicquestionID 

 FROM dynamicregistration_question where ModuleID = 402

CREATE TABLE #temp (userid int)

INSERT...

Also, here is what my query looks like when I replace the actual column names and table names. The real issue is that these are QUIDS and not integers.

CREATE TABLE...

Ok, well we are REALLY getting close here. Thanks so much for everyones help. The issue now is that I wasn't completely honest before about the table structure because I...

Oh, I think I mis-communicated what I wanted as results and thats why I can't just do the joins. Here is what I want the result set to look like.

UserID, ...

What if I wanted to order it by a particular column description?

Lets say i return these rows:

UserName  Question             Response

admin      Email Address         San Diego

admin      Password               12345

admin      Special Question     Yes

user2      Email...

I must have been smoking crack! I can't believe this for some reason I thought it would require some unions but obviously not.

Thanks