Retrieving actual work from PS 2003

[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
separate actual work on independent days.

Thank you
Jose M.

 

[Rod Gill]

Hi,

Yes, see the MSP_VIEW_TP tables. They hold time phased data by day and I
think are updated every time you publish the project.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.project-systems.co.nz/
Email rodg AT project-systems DOT co DOT nz