Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting Columns to Rows???

Status
Not open for further replies.
litalu

litalu

Computer
Joined
Mar 2, 2005
Messages
1
Location
CA
I am hoping someone can help with the following:

I have a flat table as follows:

ID, Column1, Column2, Column3, etc.

And I need to get an output as follows

ColumnName, Value
-----------------
Column1, Value
Column2, Value
Column3, Value

Thanks.
 
Status
Not open for further replies.

Similar threads

alainmarion85
  • Locked
  • Question Question
How to restore database MSSQL 2005 SP4?
Replies
2
Views
1K
alainmarion85
alainmarion85
tammy09
  • Locked
  • Question Question
SQL query, multiple dates, seprate columns
Replies
0
Views
788
tammy09
tammy09
nessty
  • Locked
  • Question Question
How to resolve SQLDiag issue
Replies
3
Views
930
genomon
genomon
MIKEJ3131
  • Locked
  • Question Question
Cannot use DISCTINCT command when combining to columns in my query????
Replies
1
Views
222
LindyBob
LindyBob
NTrade
  • Locked
  • Question Question
sql to create value dependent on prior record
Replies
1
Views
765
rtmpxr
rtmpxr

Part and Inventory Search

Sponsor

Back
Top