Re: multilevel hierarchy query

On 15 Feb 2005 10:17:15 -0800, "Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote:

>
>Bruce Hensley wrote:
>> I don't know how to begin on a query (SELECT statement) to find all
>the
>> tasks assigned to an arbitrary manager (say, staffID='JSmith') and
>her
>> organization, that is, assigned to all her underlings, and their
>underlings,
>> and .... For that matter, I don't even know how to find everyone in
>her
>> organization (at all levels).
>>
>> - All individuals have only one manager
>> - Tasks are assigned to individuals
>> - A manager at any level may have direct reports and sub-managers
>>
>> The table structure:
>>
>> tblStaff
>> -------------
>> staffID
>> reportsToID (staffID of direct manager)
>>
>>
>> tblTasks
>> --------------
>> taskID
>> assignedToID (staffID of individual responsible for task)
>>
>>
>> Any help would be greatly appreciated.
>>
>> Bruce
>

I haven't used them yet but you may find the Shaped Query for ADO helpful.

Just do a search in Google.

Good luck.
Greg Teets
Cincinnati Ohio USA Received on Tue Feb 15 2005 - 13:00:14 CST