Hello,
my table contains 2 columns .
EmpID varchar(10),ReportingToID varchar(10)
how to write a query that returns all the employees under a ReportingToID ...?
the key here is i want all the employees that are under a ReportingToID tree.
i don't know the exact number of levels under a ReportingToID
empID ManagerID
abc ""
def abc
ghi abc
jkl ghi
klk jkl
mmm jkl
Thank You
Sai