Post reply

table manupulation sql ssis

  • May 21, 2014 at 7:42 am

    #289141

    I am trying to change data in sql server. currently I have this.

    I want to change this to the end result. I want "by industry total return" in same cell as Aerospace, chemicals..... industry name.

    Date 3/27/2014 4/3/2014.......

    Aerospace By Industry Total Return 0.01% 0.04% .......

    Chemicals By Industry Total Return ..... ....

    Consumer Durables by Industry Total Return

    how can I do this?

  • May 21, 2014 at 5:54 pm

    #1715533

    With the data in the non-usable format that it is, try "ROLLUP". If you'd like a coded example, please see the first link under "Helpful Links" in my signature line below so that we can help you better. Thanks.

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