How about some ddl and an explanation of what you are trying to do?

You should start your own thread instead of jumping onto another one.

Before you start...

The point is that you have a thread trying to resolve this already. If you just start a new thread it fragments the...

But what is the error message?

Take a look at the links in my signature about cross tabs. The first one covers PIVOT and some alternative ways to do the same thing. The second one talks...

SQL_Kills (6/22/2012)

Thanks for your advice so far and what you have shown me.

The table you created QuestionFieldsNormalized was what the table originally looked like that when pulling the data from...

Do you mean intellisense? There is a version built into SSMS 2008 but...it is less than optimal. Redgate sql prompt is...

OK so once we have this somewhat normalized this type of data manipulation becomes a whole lot more manageable.

Something like this produces the desired results from your sample data.

declare @MappedField...

At the very least you should normalize your EAV pairs. This is worst of the two worst data structures combined into a single table. This just makes we want to...

Lynn Pettis (6/21/2012)

Because there are two columns with the value...

You are very welcome. Glad...

Can you explain the rules behind why ID 1 returns 1 value and ID 5 would return 2?

Check out the articles, they discuss pivot as well. 😛

First things first...I formatted this so myself and others can read it. You can help the legibility of your long code posts better by using IFCode shortcuts.

<-- They are...

Yes there is. Take a look at the cross tabs articles referenced in my signature.