Home Forums SQL Server 2008 T-SQL (SS2K8) Convert years RE: Convert years

  • October 27, 2012 at 11:11 pm

    #1553512

    Luis Cazares (10/18/2012)

    Jeff Moden (10/18/2012)

    You will need to "unpivot" or "uncrosstab" the data so that it's in a vertical format and then "repivot" or "recrosstab" to the desired layout.

    For coded help, please see the first link in my signature line below.

    As a sidebar, the original data is stored as if it were a spreadsheet, which is a denormalized form and causes a lot of the problems like the very problem you're currently having. My recommendation is that once you have "unpivoted" the data, you keep it that way.

    For this query, I'm sure he doesn't need to "unpivot" the data.

    However, I support your recommendation on keep the data normalized.

    For hard coded dates, I agree. But how often are hard coded dates going to be safe on the 1st of the next year?

    --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)