How can i detect whom a person reports to using a self-referencing employee table?
Since to me it's already a well known and solved problem, and since the commentary on here seems to agree with me:

https://stackoverflow.com/questions/3859882/sql-recursive-function-to-find-managers

Are you wanting to return the results for each lowest employee in the set, and that's what's making it hard?