Does anyone know a good tool for comparisons of databases by a threshold level? Here is a little background:
Our company tracks our product depletions from our distributors by SKU. The data is very accurate but not very robust. Because of this we also buy robust data from a vendor. This data is not always accurate. Currently we do a manual comparison of distributor level data and look for differences over a certain percentage. This is very time consuming and not all that helpful. We would like to do this at a SKU level with some sort of tool that will run off-hours and throw SKU level exceptions into a seperate table for follow-up.
I've searched quite a bit and found plenty of programs that will look for exact matches, but nothing so far that will allow a threshold before reporting an exception. Does anyone know anything that can do this? I'm not a database wizard, so I might be missing something there too. Can this easily be implemented using SQL?
Thanks!