Need SQL query to get the past dated manager
The content is, since for inactive employees the manager information will not be there after the LWD, Need a query to get the past dated manager(who was the manager when he/she left the organization).
We have already fetched this information in OTBI. I need to get it in BIP report.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):