Member Avatar for minbor

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
  • 94 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by minbor
Member Avatar for minbor

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

minbor

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.