SQL Query for returning Actual Hours

[Neil]

I need to write some SQL to extract actual hours per day per task per
resource, and total per resource per task.

Can someone point me in the right direction regards tables, fields joins etc.

thanks

Neil.

 

[Gary L. Chefetz [MVP]]

Neil:

The best direction to head is to the help files installed on your server
under the help directory of your application installation. Look for
Projdb.htm and svrdb.htm which are the data dictionaries for the respective
halves of the database, replete with sql query examples that ought to make
this job a cinch for you.