Performing Calculations between tables and comparing the result

General
1

Hi All,

I have a use case where I have a group of orders (say 10000) where I want to compare the actual charges with the expected charges. My default course of action is to have two separate tables (one for expected and one for actuals) which I then compare record by record. This feels inefficient. Is there a better way to do this? Please note that I will need to pull in a 3rd table that helps calculate the expected charges.

Thanks
Aaron

2

Hi, @Aaron_Alpeter.

I think this is question for google, like most efficient way of comparing two collections\arrays.
However, I can advice you to add logs in the begin of comparing and in the end of comparing, then try different algorithms and choose best of one.

Regards, Nikita.