Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 linked list

Author  Topic 

jraha
Starting Member

16 Posts

Posted - 2001-04-11 : 09:49:26
Hi I'm working on a pretty common problem: Storing employee information. The part I'm not sure of is this: How should manager information be stored? within a table tEmployees there is a field ManagedBy (int) This holds the EmployeeID of that row/persons manager. With this design, the query that returns all of the people who are underneath a manager takes a long long time. Any ideas on this?
   

- Advertisement -