Rows and Columns

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?Are you using SQL Server 2005 or SQL Server 2000?|||

Hi,

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

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

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

sql

Routing file to printer

Is there a way to route a file directly to a printer? I have a process that creates PDF file in a known location and I would like to route them directly to the printer after creation.

Did one of your earlier threads not answer this question?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1259522&SiteID=1|||

I did not see the earlier answer. I have posted an additional question there.

Thanks for the answer.

Routing file to printer

Is there a way to route a file directly to a printer? I have a process that creates PDF file in a known location and I would like to route them directly to the printer after creation.

Did one of your earlier threads not answer this question?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1259522&SiteID=1|||

I did not see the earlier answer. I have posted an additional question there.

Thanks for the answer.