P
Prodigal Son
Hi,
I am creating an sql query that will query the SQL Server 2000 that project
2003 is using. I am investigating the query that comes in the project 2003
SDK and this seems to be along the line of what I am looking for.
The issue I am now having is that some of the actuals that are being
returned do not appear when the project files are opened in project
professional e.g. the true actuals are returned for a particular day for a
particular resource but sometimes there a records of actuals being recorded
for different tasks they are assigned to but have not charged anything.
Resources enter their time using project web access and as an admin I
sometimes open the projects in project professional and make changes.
What I want to know is whether the folling sql statement is what is needed
to get the daily actuals that are submited by each resource.
SELECT r.RES_NAME AS Resource, p.PROJ_NAME AS Project, a.TASK_ID,
a.TASK_NAME AS TaskName, td.AssignmentTimeStart,
td.AssignmentTimeActualWork / 1000 / 60 AS Hours
FROM dbo.MSP_WEB_PROJECTS AS p INNER JOIN
dbo.MSP_WEB_ASSIGNMENTS AS a ON p.WPROJ_ID =
a.WPROJ_ID INNER JOIN
dbo.MSP_WEB_RESOURCES AS r ON a.WRES_ID = r.WRES_ID
INNER JOIN
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY AS td ON a.ASSN_UID =
td.AssignmentUniqueID
WHERE (td.AssignmentTimeActualWork IS NOT NULL AND
td.AssignmentTimeActualWork > 0) AND (td.AssignmentTimeStart >=
CONVERT(DATETIME,
'yyyy-mm-dd 00:00:00', 102)) AND
(td.AssignmentTimeFinish <= CONVERT(DATETIME, 'yyyy-mm-dd 00:00:00', 102))
Also will the database hold actuals that were already in the project before
it was originally uploaded?
Does the database get automatically updated or is there are process of
updating the database so that it hold exactly what is shown on PWA and
project professional?
Thanks in advance
ProdSon
I am creating an sql query that will query the SQL Server 2000 that project
2003 is using. I am investigating the query that comes in the project 2003
SDK and this seems to be along the line of what I am looking for.
The issue I am now having is that some of the actuals that are being
returned do not appear when the project files are opened in project
professional e.g. the true actuals are returned for a particular day for a
particular resource but sometimes there a records of actuals being recorded
for different tasks they are assigned to but have not charged anything.
Resources enter their time using project web access and as an admin I
sometimes open the projects in project professional and make changes.
What I want to know is whether the folling sql statement is what is needed
to get the daily actuals that are submited by each resource.
SELECT r.RES_NAME AS Resource, p.PROJ_NAME AS Project, a.TASK_ID,
a.TASK_NAME AS TaskName, td.AssignmentTimeStart,
td.AssignmentTimeActualWork / 1000 / 60 AS Hours
FROM dbo.MSP_WEB_PROJECTS AS p INNER JOIN
dbo.MSP_WEB_ASSIGNMENTS AS a ON p.WPROJ_ID =
a.WPROJ_ID INNER JOIN
dbo.MSP_WEB_RESOURCES AS r ON a.WRES_ID = r.WRES_ID
INNER JOIN
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY AS td ON a.ASSN_UID =
td.AssignmentUniqueID
WHERE (td.AssignmentTimeActualWork IS NOT NULL AND
td.AssignmentTimeActualWork > 0) AND (td.AssignmentTimeStart >=
CONVERT(DATETIME,
'yyyy-mm-dd 00:00:00', 102)) AND
(td.AssignmentTimeFinish <= CONVERT(DATETIME, 'yyyy-mm-dd 00:00:00', 102))
Also will the database hold actuals that were already in the project before
it was originally uploaded?
Does the database get automatically updated or is there are process of
updating the database so that it hold exactly what is shown on PWA and
project professional?
Thanks in advance
ProdSon