I understand your concern Steve.
And trust me we have systems to calculate this thing. It's just I am not able to get the scripts of how the real calculation...

Thanks Steve for your time.
The accrual, redemption and expired miles i have at transaction level in old system. The issue is, we are moving to new system where we...

Thanks Thoms for replying and sorry about the picture posted above. Newbie errors. 🙂

drop table #Breakage_Merge
create table #Breakage_Merge(rowid int,flyer_id bigint,Accrual_month date null,Accruals bigint,Expected_Expiry_month date null,