Query to Get Project Assignment Time Phased

Project Server 2003 Query to Get Project Assignments as Timephased

SELECT     dbo.MSP_WEB_ASSIGNMENTS.TASK_NAME AS [Task Name], dbo.MSP_WEB_PROJECTS.PROJ_NAME AS Project,
                      dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeStart, dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeFinish,
                      dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeWork / 60000 AS [Work], dbo.MSP_WEB_RESOURCES.RES_NAME
FROM         dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY INNER JOIN
                      dbo.MSP_WEB_ASSIGNMENTS ON dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentUniqueID = dbo.MSP_WEB_ASSIGNMENTS.ASSN_UID AND
                      dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID = dbo.MSP_WEB_ASSIGNMENTS.WPROJ_ID INNER JOIN
                      dbo.MSP_WEB_PROJECTS ON dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID = dbo.MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN
                      dbo.MSP_WEB_RESOURCES ON dbo.MSP_WEB_ASSIGNMENTS.WRES_ID = dbo.MSP_WEB_RESOURCES.WRES_ID

 

Note: Please do test this query on local development environment before testing in on production.

Jerry

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s