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 |
|
BigRetina
Posting Yak Master
144 Posts |
 Posted - 2003-08-25 : 06:45:38
|
| Salute...I have the following tables : Expenses_Categories, Markets, ExpensesI need to generate a matrix report (to be exposrted to an excel sheet) that has the following shape: Cat1 Cat2 Cat3 Cat4 ... etcMarket1 10 20 30 40 ...Market2 15 10 5 50 ...etc...Any ideas how to generate such matrix result sets?thanks |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-08-25 : 07:17:48
|
| why not send the raw data to Excel....and use pivot tables in there.horses for courses? |
 |
|
|
BigRetina
Posting Yak Master
144 Posts |
Posted - 2003-08-26 : 03:08:27
|
| I agree....this is exactly what I have in mind...BUT...i would like to LEARN how to do it in SQL!!!Thanks Anyway |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-26 : 07:37:44
|
| http://www.sqlteam.com/item.asp?ItemID=2955 |
|
|
|
|
|
|
Matrix Report Select Statement