J
James
How can i total the money earned by an manager and all his employees?
i have a table setup like this (adjacency model):
EmployeePK | EmployeeFK | Money | position
1 Null 100.00 2nd level manager
2 1 50.00 1st level
Manager
3 1 25.00 staff
4 2 30.00 staff
also, how can i find out if the employee has a specific manager level in
three separate higherarcial branches?
i have a table setup like this (adjacency model):
EmployeePK | EmployeeFK | Money | position
1 Null 100.00 2nd level manager
2 1 50.00 1st level
Manager
3 1 25.00 staff
4 2 30.00 staff
also, how can i find out if the employee has a specific manager level in
three separate higherarcial branches?