Rows and Columns

Question

I have a query that reports all of the data I want.  However it creates about 40 columns and 10 rows.  I would like to swap the display so that it shows 10 columns and 40 rows, which would cause it to print out more readable.  Can it be done?

Answer 1

Are you using SQL Server 2005 or SQL Server 2000?

Answer 2

Hi,

In SQL Server 2000 you will have to use appropiate CASE expressions, in SQL Server 2005 you can use the new PIVOT functionality-

Refer below links,

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/86e4935c-d9cc-4b5c-94a4-e00469429850/how-to-pivot-tables-in-sql-2000

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/831611f4-f05f-4467-8afe-865b0048b9ae/pivot-table-in-sql-server-2000-results-page

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Answer 3

I am using SQL 2000 which someone else said needed a CASE statement.  What I have seen seems to want to add things.  What I have is a list of numbers and then columns that are the results of my Query.

I have columns named Store , Name, Net, Tax, Deposits (and a bunch of others)

I have rows with the store numbers 2, 3, 4, 5 ,6 that I sort by

I would like the columns as rows and the store numbers across the top

Thanks