Post reply

swap columns and rows using pivot concept in sql server 2005

  • January 24, 2011 at 3:12 am

    #1277095

    The most important question: Are you using SQL Server 2005 (as indicated in the header) or SS2000 (as per the forum you posted in)? Makes a huge difference...

    You might also search this site for the keyword "TRANSPOSE". There are several solutions available.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • January 24, 2011 at 7:08 pm

    #1277569

    Hi Sandeep and welcome aboard!

    It's good that you posted data for an example but most people like to test their code before posting it as an answer. The problem with your data is it's not "readily consumable" data and a lot of people won't take the time to convert it. With that in mind, please take a look at the article at first link in my signature line at the bottom of this post... you'll get much better and quicker answers if you format your data example that way along with a relevant CREATE TABLE statement.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 3 (of 3 total)

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