Re: Retrieving Actual Work with SQL
From: Gary L. Chefetz \(MVP\) ("Gary)
Date: 10/27/04
- Next message: BillZ: "RE: Project Pro 2003 client hangs during connection to the server"
- Previous message: Michael McGinley: "Resource Usage View"
- In reply to: Jose M. Dominguez: "Retrieving Actual Work with SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 27 Oct 2004 11:30:30 -0400
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 - "Jose M. Dominguez" <Jose M. Dominguez@discussions.microsoft.com> wrote in message news:986CF8CC-1D2B-4904-8D90-7A6EE6E0D419@microsoft.com... > 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.
- Next message: BillZ: "RE: Project Pro 2003 client hangs during connection to the server"
- Previous message: Michael McGinley: "Resource Usage View"
- In reply to: Jose M. Dominguez: "Retrieving Actual Work with SQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
