Post reply

What is pivoting

  • April 14, 2013 at 11:11 am

    #276454

    What is pivoting?

    Por example:

    "An attribute of a dimension is not a good candidate for a nonclustered index key. Attributes are used fro pivoting and typpicaly contain ony a few distict values""

  • April 14, 2013 at 11:31 am

    #1606309

    The simple explanation is "converting rows to colums". For how to do that in T-SQL, please see the following article.

    http://www.sqlservercentral.com/articles/T-SQL/63681/

    In MS Excel and other "front end" reporting, pivoting is taken to the next step. This is where you have a report with, possibly, many different column categories and row groupings that you can click and drag to the opposite dimension (row groups become column categories and vice versa). In the right hands, it can be a powerful analysis tool.

    --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 1 (of 1 total)

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