Forum Discussion
Aging of accounts
I need to generate an aging report, and so far I have this code. All is working except the over 120. It will just add all the values in the Amount field. DECLARE @DateAsOf AS Date = '12/31/20...
We don't have your "sales" table to test it, so please post table design as DDL, some sample data as DML statement and the expected result.