Ok -

Ive been stumped by this one for a few days..

So I finally got access to my company's cost center database..

Basic structure -

id | costCenterName | costCentercode | parentID
1, organization, n1, <null>
2,finance, n2, n1
3, billing, n3, n1
4, accounts, n4, n3

etc..

then ive got another table that has all employees and which cost center they are in ..

So Ive been tasked with coming up with a reporting structure where someone can supply me with their costCenter code and I have to tell them how many employees they have..

Only not just their costCenter.. but their's as well as all costCenters that report up to their's...

Ive got a recursive program I can write to get this information, but with 3k costCenters and over 35k employees.. takes way to long for a report on the web..

ANy ideas on how to manipulate this data or write some kind of sql query that could return results in timely manner?

Thanks!

Will