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 - 2000-10-26 : 20:12:45
|
| Trevor writes "I have a table in SQL 6.5 under Windows NT, service pack 5 in which I need to extract a summarised total of a number of fields for a number of records. This is no problem using the SUM command. However, once the extracted data is populated into a table, I find that the rows and columns are 'swopped', i.e. I need to find a simple, quick solution to an equivalent of EXCEL's Pivot Table function - what were once rows are now columns, and vice versa. Is there such a function in SQL or ASP? Any suggestions?" |
|
|
|
|
|
Pivot tables in SQL