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!

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

Pivot

Status
Not open for further replies.

dechrist

Programmer
Sep 24, 2008
10
US
I have the following in a table in Teradata (the actual table has about 60 columns):

Dept Group Col1 Col2
100 1 A D
100 2 B E
200 1 C F

I would like to get:

Dept 100 100 200
Group 1 2 1
Col1 A B C
Col2 D E F
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top