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-18 : 19:00:00
|
Geno writes "I'm having a hard time understanding the idea of cross tabs. I have a table that stores file CRC's. | build | filename | crc |
|---|
| b100 | thisfile.exe | 0x1234abcd | | b100 | thatfile.dll | 0xabcd1234 | | b200 | thisfile.exe | 0x2345cbde | | b200 | thatfile.dll | 0xbcde2345 |
I want to display the table like this:| filename | b100 | b200 |
|---|
| thisfile.exe | 0x1234abcd | 0x2345cbde | | thatfile.dll | 0xabcd1234 | 0xbcde2345 |
Any hints on the SQL for this?Thanks,Geno" |
|
|
|
|
|
Cross tab Reports