Unanswered: Need Help with either using Pivot or Crosstabs
I am a bit of a SQL Server 2005 newbie. I have to run a report extracting survey responses for my group using SQL Server. My question is what is the best way to organize the data so it converts from rows into columns. I know SQL Server was not meant for creating presentation reports but I have over 800 surveys that I compile so any help would be appreciate. I have to extract data from 2 tables within a view.
For example, I would like the data show in this format:
Last Name|First Name|Question1|Question2|Question3|..etc