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 |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2003-09-24 : 14:31:28
|
| I was wondering if Robvolks crosstab query could be modified to aggregate varchar values (ie. I don't want to sum, count, etc,.. anything I just want to pivot the report).Heres my situation.I have a table containing EMPLOYEE, MATCHUP(ie. dolphins vs. jets), and PICK (ie. dolphins).I would like to display the employees as the column, the matchups as the row header, and the Pick as the aggregated column.I've tried modifying RovVolks proc a bunch of different ways and I can get the pick to display but with a bunch of null for all the other columns.any ideas?thanks. |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2003-09-24 : 15:36:33
|
quote:
Originally posted by mdelgado
I've tried modifying RovVolks proc a bunch of different ways and I can get the pick to display but with a bunch of null for all the other columns.
Does that include using either MAX() or MIN() for the aggregate? |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-09-24 : 20:37:34
|
Hey drymchaser! Congrats on hitting 100!  And yes, Max and Min are the only aggregate functions that work on non-numeric values, but they work fine for cross tabs. |
|
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2003-09-25 : 07:11:13
|
| that's what it was!thanks for your reply.... |
|
|
|
|
|
|
another crosstab question using Master Robvolk sp.