0

Hello,
I would appreciate if anyone could help me with this. I'm new to this sort of thing and don't really know where to start. I have a survey results table that looks like this:

user  question  answer
Mike       1       2
Mike       2       1
Mike       3       5
John       1       5
John       2       3
John       3       4

and i have to get the data look like this:

user   q1   q2   q3
Mike   2    1    5
John   5    3    4

I don't mind if this is a SQL server report, .asp web page or a text file, as long as it is readable.

All ideas very welcome.

minbor

1
Contributor
1
Reply
2
Views
8 Years
Discussion Span
Last Post by minbor
0

Hi, I understand that I can't askt anyone to write the whole query, but any pointers would be very appreciated.

minbor

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.