SQL Check - Query for Baselines - Crosstab ?

[Trent Helms]

In our organization we have the need to compare baselines level 0 to
level 3 for every project. Our procedure would have us using the save
baseline feature as the end of each initial four phases of our project
life cycle.

I need to confirm how to retrieve the information if the project is
stored in database format and using SQL.

I'm not sure which baseline table I want to use but for now I'm using
the baseline work field from the tasks table and the first three
records from the baseline tasks table.

I think the best way to get the information is to use a crosstab
query. It is below so if you have any better approach or I'm off on
the wrong tangent please let me know.

TRANSFORM Sum(MSP_TASK_BASELINES.TB_BASE_WORK) AS SumOfTB_BASE_WORK
SELECT MSP_PROJECTS.PROJ_NAME, MSP_TASK_BASELINES.PROJ_ID,
Sum(MSP_TASKS.TASK_BASE_WORK) AS [Level 0]
FROM (MSP_PROJECTS INNER JOIN MSP_TASKS ON MSP_PROJECTS.PROJ_ID =
MSP_TASKS.PROJ_ID) INNER JOIN MSP_TASK_BASELINES ON
(MSP_TASKS.TASK_UID = MSP_TASK_BASELINES.TASK_UID) AND
(MSP_TASKS.PROJ_ID = MSP_TASK_BASELINES.PROJ_ID)
WHERE (((MSP_TASKS.TASK_ID)=0))
GROUP BY MSP_PROJECTS.PROJ_NAME, MSP_TASKS.TASK_BASE_WORK,
MSP_TASK_BASELINES.PROJ_ID
ORDER BY MSP_TASK_BASELINES.PROJ_ID
PIVOT MSP_TASK_BASELINES.TB_BASE_NUM;

Additionally I would like to query for the baseline save date. I've
seen a few posts stating that it is or was saved in binary format. If
this has changed in Project 2002 Pro please let me know. So far I
don't see the values in any table.

Thanks in advance!

Trent Helms
(e-mail address removed)