Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

Phaneuf3 · 06-04-2010, 03:07 PM

I'll do my best to simplify my question... It seems like it should be fairly simple but it's Friday afternoon and my brain just isn't working right...

If I have a very simple SQL query to return a single row based on it's index to get something like this:

Code:

SELECT * FROM Table1 WHERE Index = 1


Index   A     B     C    D     Z
------------------------------
1         1    2     3     4      26

Is there any simple way I can alter my query to have it return like this:

Code:

Column Name       Value
-----------------------
A                        1
B                        2
C                        3
D                        4
Z                        26

06-04-2010, 03:07 PM	#1
Phaneuf3 First Line Centre Join Date: Oct 2005 Exp:	SQL Question I'll do my best to simplify my question... It seems like it should be fairly simple but it's Friday afternoon and my brain just isn't working right... If I have a very simple SQL query to return a single row based on it's index to get something like this: Code: SELECT * FROM Table1 WHERE Index = 1 Index A B C D Z ------------------------------ 1 1 2 3 4 26 Is there any simple way I can alter my query to have it return like this: Code: Column Name Value ----------------------- A 1 B 2 C 3 D 4 Z 26