B
Brian Linsner
I am trying to recreate the MS Project Server 2003 Task Usage Report outside
of MS Project. I have a SQL query that works for most days but it seems to
stop reporting correctly when I get close to the current date. Does anyone
know of a better query to use or another table that I should be looking in?
Here is my query:
SELECT AssignmentTimeStart, SUM(AssignmentTimeCost) * 0.00016665 AS Work
FROM dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY WHERE (ProjectUniqueID = 758) AND
(AssignmentTimeStart > CONVERT(DATETIME, '2006-02-15 00:00:00', 102)) AND
(AssignmentTimeFinish < CONVERT(DATETIME, '2006-07-26 00:00:00', 102))
GROUP BY AssignmentTimeStar
of MS Project. I have a SQL query that works for most days but it seems to
stop reporting correctly when I get close to the current date. Does anyone
know of a better query to use or another table that I should be looking in?
Here is my query:
SELECT AssignmentTimeStart, SUM(AssignmentTimeCost) * 0.00016665 AS Work
FROM dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY WHERE (ProjectUniqueID = 758) AND
(AssignmentTimeStart > CONVERT(DATETIME, '2006-02-15 00:00:00', 102)) AND
(AssignmentTimeFinish < CONVERT(DATETIME, '2006-07-26 00:00:00', 102))
GROUP BY AssignmentTimeStar