Need to create a SQL 2008 crosstab/pivot table
Posted on 2012-08-29
I have two tables that I need to join, but the results in one table are the filed names in the other table.
Table 1 contains these two fields...
qtext is the text of a question
qfield is the actual field name of the question in another table
Table 2 contains the following fields...
*These field names are the results of qfield in Table 1
Table 1 results:
Select qfield, qtext
question_1 How many people are in your family?
question_2 How old is the oldest person in your family?
question_3 How old is the youngest person in your family?