Thanks for both the great responses.  Adding the clustered index has greatly reduced the execution time.

We are now having a PeopleManagers table which holds who a persons supervisor is.  This is...

Hi,

Did you ever find the answer to this problem.  I have found other forums where people have had this problem but i have been unable to find a solution.

Any...