End month balance and calculate supportable
I tried looking for some solution here, but still stuck.
Running total/Cumulative SUM for Ungrouped Data SQL
Looking to create running totals for ungrouped data in SQL. I’m looking to do a rolling sum of PAID_AMOUNT by INCURREDMONTH and PAIDMONTH. For example,
Calculated column in SQL based on multiple column matches between two tables and cumsum
Calculated column in SQL based on multiple column matches and cumsum between two tables