ProjectServer2007允许用户对项目、任务、资源、分配添加自己的定制数据，
定制数据分为两类，一类是以字符串（数据表为MSP_EpmCPxxxStr0）直接保存，另一类是保存某个查阅表格中值对应的ID（数据表为MSP_EpmCPxxxUid0），可用下面的SQL查询这两类定制数据，

select
  p.projectuid,
  p.projectname,
  lt1.memberfullvalue as 项目类别,
  cpps0.cfval0 as 测试一
from
  msp_epmproject as p
LEFT OUTER JOIN dbo.MSP_EpmCPPrjStr0 cpps0
  ON cpps0.EntityUID = p.ProjectUID
LEFT OUTER JOIN dbo.MSP_EpmCPPrjUid0
  ON dbo.MSP_EpmCPPrjUid0.EntityUID = p.ProjectUID
LEFT OUTER JOIN dbo.MSP_EpmLookupTable AS lt1
  ON lt1.LookupTableUID = '61D944EA-8848-4D01-AE21-B0A24F9CA47F'
  AND lt1.MemberUID = dbo.MSP_EpmCPPrjUid0.CFVal2

注意: 定制数据对应的是哪个CFVal要看实际情况.