How to interchange rows and columns in SQL?

  • Can anbody please help me in interchanging rows with columns

  • look at the PIVOT command in BOL

    ...and your only reply is slàinte mhath

  • Read up on the PIVOT keyword in BOL or search this site. There are plenty of examples around. 😉

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • Sorry to say this..I am new to SQL...what is BOL? can anyone provide me with a query as a solution

  • "Books Online" It can be found

    Start > Programs > Microsoft SQL Server 2005 > Documentation and Tutorials > SQL Server 2005 Books Online

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • Thanks a lot..i will take it from here..thanks once again

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply