Rows and Columns

i have query reports of data want.  creates 40 columns , 10 rows.  swap display shows 10 columns , 40 rows, cause print out more readable.  can done?

hi,

in sql server 2000 have use appropiate case expressions, in sql server 2005 can use 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
---

SQL Server  >  Getting started with SQL Server