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 |
|
wgpubs
Yak Posting Veteran
67 Posts |
 Posted - 2005-04-20 : 14:08:19
|
| I have data reported as follows via a simple select query ...AnsValue AnsCount1 32 93 174 525 22na 0I would like to report this data horizontally as such ...1 2 3 4 5 na3 9 17 52 22 0Basically AnsValue becomes the column and AnsCount becomes the column value. Any ideas on how to do this???Thanks - wg |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2005-04-20 : 15:36:55
|
| I suppose telling you that Pivot will be available in sql server 2005 isn't going to help?________________________________________________Bier is a privelege of the working man (or woman). |
 |
|
|
wgpubs
Yak Posting Veteran
67 Posts |
Posted - 2005-04-20 : 15:41:21
|
| unfortunately not at this point :)any ideas on how to do it in SQL 2K would be helpful though :) |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
how to report vertical data horizontally???