C#

// Initialize the reset events to keep track of completed threads
               ManualResetEvent[] resetEvents = new ManualResetEvent[arrFileName.Count];

               // Launch each method in it's own thread
               for (int i = 0; i < arrFileName.Count; i++)
               {
                   resetEvents[i] = new ManualResetEvent(false);
                   ThreadPool.QueueUserWorkItem(new WaitCallback((object index) =>
                   {
                       int actionIndex = (int)index;

                       // Execute the method
                       ThreadExcecute(arrFileName[actionIndex]);

                       // Tell the calling thread that we're done
                       resetEvents[actionIndex].Set();
                   }), i);
               }

               // Wait for all threads to execute
               WaitHandle.WaitAll(resetEvents);

Users report to a manager
1. The process by clicking a button is finding who reports to me (manager)
2. So there is a stored procedure written to find the users reporting to the manager

My question is:
1. Is this the right way of doing this
2. Is there a need to develop a separate SQL view just for this report
3. What would be the best approach on doing this.