I want to run a report/query to find everyone that reports to person A or anyone that reports to someone that reports to someone that reports to person A on down, down, down until I get them all.
Seems like it would be some sort of nested dynamic SQL. Anyone have any pointers on how to go about something like that?
