• I have a table like below:



    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



  • duplicate post.

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

    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