I would like to have a query wherein I would like to transpose the contents of one table onto another table. Let's say my first table has 5 rows and 3 columns and I have created a table with 3 rows and 5 columns .
Can anybody suggest an efficient way. I have tried to do it using multiple insert statements but want to know a better way .
Any suggestions would be helpfull