Retrieving Actual Work with SQL

J

Jose M. Dominguez

Hello:

I'm using Project Prof 2003 and Project serevr 2003.

I want to retrieve actual work from the database (from MSP_WEB_WORK table).

I know that actual work is stored in one entry for common values of work and
task on subsequent days.

I'd love to know if someone has done an SQL stored procedure or similar to
isolate actual work on independent days.

Thank you
Jose M.
 
G

Gary L. Chefetz \(MVP\)

Jose:

First of all, be aware that actual work is stored in more than one way in
the database. I suggest that you navigate to the help directory under your
Project Server installation directory on the server and grab the two HTML
documents: projdb and svrdb which contain the data dictionaries for the
database as well as code samples for doing exactly what you ask.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieving actual work from PS 2003 1
Prevent the PM from unintentionally change the actual work 4
Entering Actual Duration & Actual Work 7
Work stored in the database - MSP_WEB_WORK 8
actual work timesheet 3
Actual Work and Duration 2
Decimal rounding issue when actual work greater than planned. 2
Actual work lost with change to summary task 0

Top