@DynamicForms_QuestionResponse is a table variable in my example. You'll want to remove the '@' symbol and replace it w/ dbo. if you want to run this same query against...

Well, this gives you the results that you are looking for (I think) based on your original query's DynamicQuestionIDs. But my question is, how do you know from the...

So based on the 8 rows of sample data that you've shown us. What do you want the result set to look like? Can we figure out what...

OK. Now we have sample data to work with...Here it is in a usable format:

DECLARE @DynamicForms_QuestionResponse TABLE(

DynamicQuestionResponseID uniqueidentifier ,

...

It should not matter where the data comes from. Grab (SELECT) a few rows from you table and post them in the forum.

acogswell (5/13/2010)

I want to take each row, after Response (which is the header pulled from the Select Top 15 RESPONSE) and add a column with each of these names:

Presentee, Factory,...

Your formatting is not the problem. We need to know the table structure and see some sample data to help. Can you post your DDL for DynamicForms_QuestionResponse? ...

If you can give us an example of your table, data, and an example result set, this should not be to difficult to help you with. Please read the...

Blarney Stone.

exponential

Played Fossil Trace in Golden, CO this weekend.....nice course.

crookj (5/6/2010)

sing4you (5/6/2010)

Don't forget Texas. It may be hell to...

Training (Teradata).

Was there a full moon again in...

Steve, can you combine these 2 threads and make bacon covered chocolate croissants?