re-arrange data from sql select statement
Posted on 2011-09-08
I have a table that looks like this
A B C
1 A2 B2 C2
2 A3 B3 C3
3 B4 B4 C4
I want to do a select statement that displays the data like this
1 2 3
A A1 A2 A3
B B1 B2 B3
C C1 C2 C3
The reason why i need this is because there is 200 columns in this table and only 8 rows.
I need to be able to print it on portrait 8.5x11 sheets of paper. If I print the table as is, it will be waaay too wide to print on a piece of paper.
This is a pricing sheet for our sales people to use to quote products for phone customers. I just need to get this info out in a legible format for them to read.
If there is a better way that doesn't cost any more money I'm open to suggestions.