Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-24 : 07:27:06
|
| Don writes "I am having a tough time trying to create a cross tab query in SQL. This is a very complex query that has a lot of computations it. I finally got all of that to work and now I have to transform it if you will into a cross tab or pivot table which ever one is best and will work. What I need to do is have it show the data for each factor with the user as the colums. So basically it will show each factor for a given survey for each user as the colum headings extending to the right. I am having a hard time and I can send the actual SQL statements but I have to be very careful about it because of a confidentiality aggreement with my client. Please help I am stuck on this on and I have to finish this project!!!!!!" |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-06-24 : 08:52:48
|
| http://sqlteam.com/item.asp?ItemID=2955 |
 |
|
|
|
|
|
Cross Tab Query