Home Forums SQL Server 2008 SQL Server 2008 - General Running Values ( Cummulative) RE: Running Values ( Cummulative)

  • September 5, 2012 at 7:32 am

    #1533805

    farooq.hbs (9/5/2012)

    This is sample table

    EventYear EventMonth Item_name Value Cummulative_Total

    2012 9 Forcast 1 1

    2012 1 Actual 2 3

    2012 10 Forcast 3 9

    2012 2 Actual 4 13

    2012 11 Forcast 5 18

    2012 3 Actual 6 24

    2012 12 Forcast 7 31

    2012 4 Actual 8 39

    But I need:

    EventYear EventMonth Item_name Value Cummulative_Total

    2012 9 Forcast 1 13

    2012 1 Actual 2 2

    2012 10 Forcast 3 16

    2012 2 Actual 4 6

    2012 11 Forcast 5 21

    2012 3 Actual 6 12

    2012 12 Forcast 7 28

    2012 4 Actual 8 12

    2012 5 Actual 0 12

    2012 6 Actual 0 12

    2012 7 Actual 0 12

    2012 8 Actual 0 12

    this is how i need..cummulate Value With Missing Month Actual till Getdate()

    Forcast from Getdate()

    Please post the data in a readily consumable format. See the first link in my signature line below for how to easily do that. Thanks for helping us help you.

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