Post reply

Unpivot

  • October 18, 2010 at 7:48 am

    #239839

    I have a table like below:

    Emp

    ====

    id name

    -- -----

    1 x

    now, i want the resuts in the below format:

    col1 col2

    -- ---

    id 1

    name x

    Can someone tell me how should achieve it using UNPIVOT

    thanks


    erajendar

  • October 18, 2010 at 2:53 pm

    #1238740

    duplicate post.

    please continue at http://www.sqlservercentral.com/Forums/FindPost1006219.aspx


    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]

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

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