#dataengineering

Calculate Monthly Account Balance and Fill in Missing Dates — From SQL to SPL #10

Problem description & analysis: There is a transaction table for the asset accounts in the MS SQL database, with dates that are not consecutive. Task: Now we need to calculate the balance of each account for each month from January 2021 at the begin...