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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert multiple rows into multiple columns

Status
Not open for further replies.
pavikavi

pavikavi

Programmer
Oct 28, 2003
8
US
I need to convert rows of data into table of columns for example

id key val
1 A 11
1 B 12
2 A 22
2 B 33

i want

ID A B
1 11 22
2 22 33

Can any one help me out please

Thanks
pavithra
 
Status
Not open for further replies.

Similar threads

cbsm
  • Locked
  • Question
select rows that are not locked
Replies
0
Views
337
cbsm
cbsm
mark1110
  • Locked
  • Question
import text file into sybase table
Replies
1
Views
202
PDreyer
PDreyer
mireles10
  • Locked
  • Question
DELETE SEVERAL ROWS
Replies
2
Views
237
PDreyer
PDreyer
djjd47130
  • Locked
  • Question
Converting Sybase DB to MSSQL
Replies
1
Views
224
djjd47130
djjd47130
maddyforums
  • Locked
  • Question
Concatenation of multiple rows into a single row (sybase)
Replies
5
Views
500
PDreyer
PDreyer

Part and Inventory Search

Sponsor

Back
Top