sql query

[impulse24]

Hi,

I have a database table with the fields below, and also sample results of a query. I am trying to generate a report showing all the programmer's employeenum's that report to the top level Design Managers.

Employeenum|Managernum|EmployeeType
1234 3456 Programmer
3456 8910 Senior Programmer
8910 5678 Microsoft Certified Design Manager
9090 7878 Programmer
7878 6612 Senior Programmer
6612 5678 Unix Certified Design Manager

I am trying to figure out that Programmer1234 reports to 8910 Microsoft Certified Design Manager, and that Programmer9090 reports to 6612 Unix Certified Design Manager. Can someone please help with the correct sql statement. Thanks.

 

[tlbroadbent]

Check the following links for SQL solutions.

http://www.intelligententerprise.com/001020/celko.shtml

http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html

The following links are MS SQL Server oriented but may provide some ideas.

http://www.sqlteam.com/ItemPrint.asp?ItemID=1353

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=19663&pg=1

http://msdn.microsoft.com/library/en-us/dnsqlmag01/html/recursion.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.