I've missed out one more point. If member doesnt have transaction for any day for any TransactionType then we need to create that record in TransData table.

Regards,

Naresh Kumar

Hi Lowell,

Thanks for your reply. Please see code below and I've attached one excel file which contains table details (no sample data, this i cannot provide 🙁 )

Code

====

create procedure...