Query to identify BPA changes
Summary:
Query to identify BPA changes
Content (please ensure you mask any confidential information):
I am building a query to identify BPA's that have had their UNIT_PRICE, UOM, Vendor, Vendor Trading Partner Item #, Manufacturer, Manufacturer Part # changed in the last 'X' number of days. I have the below query to look for any changes to these fields and also look at the previous data for that record. The issue is that because I have to call the tables twice (once to get the latest row, and again to get the prior row) along with the multiple OR
conditions it is causing major performance issues.
0