Hello All,
Apologies if this is the wrong forum section.
Some help and advice please regarding a SQL Report.
It is for a Feedback form and below is a quick mock up of the DB diagram
[IMG]http://img219.imageshack.us/img219/4102/feedbackbr8.jpg[/IMG]
tblFeedback is populated with a Customers details and the tblResults with the Results of each question they answered.
When I'm currently running a report the data is displayed thus:
|_Name___|_Email____________|_Comments_______|_Question______________|_Response_|
Bob Joe--- bobjoe@email.com --- Great Service ----- Would you come again ---- Yes
Bob Joe--- bobjoe@email.com --- Great Service ----- Would you recommend ---- Yes
Bob Joe--- bobjoe@email.com --- Great Service ----- Would you buy from us ---- Yes
Each row corresponds to one question and a lot of data is duplicated, it detracts from the important information.
What I would prefer is something like the following:
|_Name___|_Email____________|_Comments________|_Q1__|_Q2__|_Q3_|_Q4___|_Q5_|_Q6__|_Q7___|
Bob Joe--- bobjoe@email.com --- Great Service ------- Yes -- Yes -- No -- Maybe - No -- Yes -- Maybe
After reading a number of resources, I think a pivot table may help, this will turn the data in tblResults from rows into columns and I should be able to append this via a temporary table.
Any brave forummer willing to look into this problem? [IMG]http://www.sql-server-performance.com/forum/icon_smile.gif[/IMG]
Many Thanks