Hi,
I need help on Pivoting a table. I have to do it in the back end only.
Here is the table that returns the data...
VS F1 F2F3F4F5F6F7F8
----------------------------------
V1 23456789
V2 23456789
V3 23456789
And I have to show this table in the below format. Can this be doable in sql server 2005?
VSV1V2V3
-----------------------------------
F1222
F2333
F3444
F4555
F5666
F6777
F7888
F8999