Forum Discussion
Anonymous
8 years agoNot applicable
PATHCONTAINS COUNT Dependants
I have a table with all the employess and their boss
Emp_ID Boss_Id PATH Dependands
1 1 5
2 1 1 | 2 3
3 1 1 | 3 0
4 2 1 | 2 | 4 2
5 4 1 | 2 | 4 | 5 1
6 5 1 | 2 | 4 | 5 | 6 0
I need to have a column added where it will tell me the total dependants (including direct and indirect), example of calculation needeed above.
Basically I need to count all the files that the pathcointains the Emp_ID of each row.
Thanks in advance,
Sebastián
No Replies