Require query for Actual Work Per day

[vikas.kurane]

I am using Microsoft Project 2000. I saved mpp file using Save As option with enabling 'Expand timephased data in database' option in Tools-Options-Save option, as a project database in Sql server

Using Resource Usage View, i am not able to make a query in Sql which will return me specific task, resource & hrs per day

I want to make a query which will return a result like timescaled calendar view appears in Task/Resource Usage View which shows "per day how many hrs a particular resource has worked for a specific task".

 

[JackD]

Please read the document titled projdb.htm
It should be on your project CD or any computer with Project installed on
it.
It discusses working with timescaled data.

-Jack

I am using Microsoft Project 2000. I saved mpp file using Save As option

with enabling 'Expand timephased data in database' option in
Tools-Options-Save option, as a project database in Sql server.

Using Resource Usage View, i am not able to make a query in Sql which will

return me specific task, resource & hrs per day.

I want to make a query which will return a result like timescaled calendar

view appears in Task/Resource Usage View which shows "per day how many hrs a
particular resource has worked for a specific task".