Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Getting rid of cursors RE: Getting rid of cursors

  • September 19, 2016 at 11:40 am

    #1901699

    I edited and added the comma. Sorry. Current result is

    EffectiveDateHolderHQuantityTQuantityPercentage

    2001-01-01John 10 10 100

    2001-01-02John 10 20 50

    2001-01-02Peter 10 20 50

    2001-01-03John 5 15 33

    2001-01-03Peter 10 15 66

    2001-01-04Peter 10 10 100