Do GUIDS Change in PS 2007?

[BoggyBoy]

I have a SQL Select statement that does a join of 2 Tables in the Reporting
Database.

The join is based on matching ProjectUID, AssignmentUID, TaskUID and TimeByDay

The two tables being joined are MSP_EpmAssignmentBaselineByDay and
MSP_EpmAssignmentByDay.

My query yeilds fewer results than I expect. One explanation is that one or
more GUIDS change. I hope this is not true. Can anyone confirm?

 

[Rod Gill]

No, GUIDs do not change. Try just linking ProjectUID and AssignmentUID or
just Assignment UID and see what results you get.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[BoggyBoy]

I did try that already but with the same result. The join also produces
less results as the project ages. Any ideas?

 

[BoggyBoy]

Correction... I tried linking ProjectUID, AssignmentUID and TimeByDay with
that result.

 

[Rod Gill]

What exactly do you mean by that?

MSP_EpmAssignmentBaselineByDay and MSP_EpmAssignmentByDay are best linked to
teh EPMAssignment table (AssignmentUID only) and from there to teh Project
table (ProjectUID only). I do this all the time with no problems.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[BoggyBoy]

Rod, I really appreciate your help on this. Indeed the GUIDs do not change
(thank goodness). The answer to my problem turned out to be the fact that
the MSP_EpmAssignmentByDay table grows as the schedule moves to the right.
For example, say the project is delayed by 10 days. I now see that new
records are created to capture the 10 day slip - each distinguished by a
different TimeByDay The AssignmentBaselineByDay remains as it was. This
accounts for my join issue.

In case you are wondering why I'm doing this, I'm staging some data that
will be used for Earned value calculations.

Best regards, John

Thanks again.