首先 我在Project Server的企业域中重命名以下企业域和企业大纲代码：
任务成本企业成本1(企业成本1)任务标志2企业标志2任务工期企业工期1任务日期企业日期1任务数字企业数字3任务文本2企业文本2任务企业大纲代码1任务企业大纲代码2
说明（以上企业域和企业大纲代码均属任务类别）
具体SQL语句如下：
SELECT MSP_VIEW_PROJ_TASKS_STD.TaskName AS '任务名称', MSP_OUTLINE_CODES.OC_NAME AS '大纲代码1', MSP_OUTLINE_CODES_1.OC_NAME AS '大纲代码2', MSP_VIEW_PROJ_TASKS_ENT.TaskEnterpriseCost1 / 100 AS '任务成本', MSP_VIEW_PROJ_TASKS_ENT.TaskEnterpriseDate1 AS '任务日期', MSP_VIEW_PROJ_TASKS_ENT.TaskEnterpriseDuration1 / 4800 AS '任务工期', MSP_VIEW_PROJ_TASKS_ENT.TaskEnterpriseFlag2 AS '任务标志', MSP_VIEW_PROJ_TASKS_ENT.TaskEnterpriseNumber3 AS '任务数字', MSP_VIEW_PROJ_TASKS_ENT.TaskEnterpriseText2 AS '任务文本'FROM MSP_VIEW_PROJ_TASKS_ENT INNER JOIN MSP_VIEW_PROJ_TASKS_STD ON MSP_VIEW_PROJ_TASKS_ENT.WPROJ_ID = MSP_VIEW_PROJ_TASKS_STD.WPROJ_ID AND MSP_VIEW_PROJ_TASKS_ENT.ENT_TaskUniqueID = MSP_VIEW_PROJ_TASKS_STD.TaskUniqueID INNER JOIN MSP_OUTLINE_CODES ON MSP_VIEW_PROJ_TASKS_ENT.TaskEnterpriseOutlineCode1ID = MSP_OUTLINE_CODES.CODE_UID INNER JOIN MSP_OUTLINE_CODES AS MSP_OUTLINE_CODES_1 ON MSP_VIEW_PROJ_TASKS_ENT.TaskEnterpriseOutlineCode2ID = MSP_OUTLINE_CODES_1.CODE_UID INNER JOIN MSP_PROJECTS ON MSP_OUTLINE_CODES.PROJ_ID = MSP_PROJECTS.PROJ_ID AND MSP_OUTLINE_CODES_1.PROJ_ID = MSP_PROJECTS.PROJ_IDWHERE (MSP_VIEW_PROJ_TASKS_ENT.ENT_ProjectUniqueID = 43) AND (MSP_PROJECTS.PROJ_TYPE = 2)ORDER BY MSP_VIEW_PROJ_TASKS_ENT.ENT_TaskUniqueID
其中具体请参见Project 2003相关数据文档PJDB.Htm以及PJSVRDB.HTM数据库文档。
