Post reply

UNPIVOT on mutiple columns

  • June 14, 2010 at 5:17 am

    #236435

    Hi All,

    Please let me know can we include two columns in UNPIVOT query. Does any body have sample query for it:ermm:

  • June 14, 2010 at 5:25 am

    #1179776

    I guess it is simple (taken from msdn):

    UNPIVOT < unpivot_clause >

    Specifies that the input table is narrowed from multiple columns in column_list into a single column called pivot_column.

    I would suggest to detail your question a bit:

    1. Add table structure setup and data

    2. Describe and show desired results

    Regards

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

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

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