G
Guest
A description of your table structure would be very
helpful.
with has over 2500 employees in it and has 4 or 5 levels
of reporting. Ex. A supervisor typically has 20 direct
reports and their manager usually has 3 supervisors
reporting to him, therefore he would have 63 direct
reports. I would need the query to do this for everyone
in my database and I am not sure how to get started with
it.
helpful.
direct reports a manager has? The database I am working
with has over 2500 employees in it and has 4 or 5 levels
of reporting. Ex. A supervisor typically has 20 direct
reports and their manager usually has 3 supervisors
reporting to him, therefore he would have 63 direct
reports. I would need the query to do this for everyone
in my database and I am not sure how to get started with
it.