AAP Promotions Report
Summary:
We have a requirement to report on employee promotions. This report should export on one line what their previous job/position was, and what their new/current position is. The problem we're running into is that the report is not getting the correct history. Right now the report is only looking at the top two records on employees' HR records. So, if an employee has additional activity on top of the promotion, it does not populate on the report. I think I have gotten close with some logical SQL to build this export, but I can't quite