Results 1 to 2 of 2

Thread: SQL Query

  1. #1
    Join Date
    Oct 2003
    Posts
    19

    Unanswered: SQL Query

    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

    Thanks
    Saurav

  2. #2
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    140
    This is a recurrent problem. Just search for "Transpose" in this forum, and you will certainly find earlier threads with solutions and links to solutions.

    Good luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •