Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts

Wednesday, March 21, 2012

Nested Sets Problem

I'm trying to see if this is possible. I have an employee table that
contains employee ID and manager ID. I'm trying to string together the
complete hierarchy for an employee in one row. So, if you have employee ID
1
reports to 2. Employee 2 reports to 3, then the result would be:
EmployeeID ReportingTo
1 2/3
Is this possible using nested sets? Can someone please give me some samples
of this?Have you searched google groups to see if there are solutions for similar
problems? If not look for "Joe Celko"+"nested sets".
Anith|||Susannah,
You should find a few useful things here:
http://groups.google.co.uk/groups? ...er+itzi
k
Steve Kass
Drew University
Susannah wrote:

>I'm trying to see if this is possible. I have an employee table that
>contains employee ID and manager ID. I'm trying to string together the
>complete hierarchy for an employee in one row. So, if you have employee ID
1
>reports to 2. Employee 2 reports to 3, then the result would be:
>EmployeeID ReportingTo
>1 2/3
>Is this possible using nested sets? Can someone please give me some sample
s
>of this?
>

Wednesday, March 7, 2012

Needed to connect Remote DB by Client Tool (Enterprise Manager)

Here is what I knew: usr/pwd, Domain, Server and Database.

How to set Enterprise Manager, then can I connect to DB ?

Take a look at the following:

Connecting to your SQL Database using Enterprise Manager

HTH