Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Help with complicated running balance RE: Help with complicated running balance

  • April 20, 2013 at 10:29 am

    #1608482

    gcresse (4/15/2013)

    I have a challenge that I was hoping to solve using the new SQL Server 2012 running balance capabilities, but it's a bit more complicated than I realized. I've attached a small spreadsheet with some sample data.

    Hi Gina

    I remember a similar requirement from a year or two ago - how did you solve it then, and how different is the requirement now?

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]