Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
venkachi
Starting Member
1 Post |
Posted - 2013-04-17 : 04:07:13
|
actually my table data isKey valuefirstname suryafirstname rakhifirstname venkatfirstname shankarfirstname danyI want to disply like firstnamesuryarakhivenkatshankardanyi write the below querySELECT firstname FROM test pvt PIVOT (MAX(pvt.value ) FOR pvt.key1 IN (firstname)) AS Pbut it showing firstnamevenkatPlease help to solve this |
|
satheesh
Posting Yak Master
152 Posts |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|