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 |
|
SQLCode
Posting Yak Master
143 Posts |
 Posted - 2004-04-26 : 11:08:47
|
| Hello all,I would like to know what options we have to generate cross-tab queries/reports. I checked BOL and didn't get any detailed explantions/examples. Can anyone here help me or direct me to any web resources pls. ?We have about a hundred courses that I want as columns and about 150000 trainees that should be the rows. The clients has been wanting it this way all along. Right now they (here) do it with Access. In my opinion, what Access does, SQL Server should also be able to do. I want to eliminate the extra maintaining part of SQL to Access to excel and eliminate Access.Any advice?TIA |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-04-26 : 11:15:32
|
| This site has many threads on cross tabs.Search and you shall find :)Duane. |
 |
|
|
|
|
|
Cross Tab