SQL query ActualsByWeek

[Studer]

Hello,
finding the stored procedure named "sp_psactualsbyweek.sql" was a big jump
forward in the quest for the SQL Query I need. The thing is that this query,
for me, isn't totaly perfect...

1.- I need the results to be grouped and ordered by project and not by
resource

2.- An other thing is that I need it to have an extra column with the
standard rate of the resource. That's the one we use for doing our financial
control of the projects.

Can anyone help me on this one?

Cheers,

Studer

 

[Andrew Jacks]

G'day

Which version of Project Server are you using as I cannot find this sproc in
either 2003 or 2007

Could you also let us know which database it is in

Thanks

 

[Studer]

I'm using 2003

Found it on the net, more precisly here:

http://msdn.microsoft.com/en-us/library/aa208968(office.11).aspx

It comes on de Project 2003 Software Development Kit (SDK) and it's in the
"Extracting Timaphased Data" folder.

After trying to run it the first time, I got the message I allready had it.
Maybe originally it doesn't come with Project Server and the last System
Administrator installed it himself.

It's good stuff.