Хабр Курсы для всех
РЕКЛАМА
Практикум, Хекслет, SkyPro, авторские курсы — собрали всех и попросили скидки. Осталось выбрать!
use ProjectServer_Published
SELECT Assgn1.PROJ_UID, Proj1.PROJ_NAME, Proj1.WRES_UID, Res2.RES_NAME AS PROJ_MANAGER, Assgn1.WRES_UID_MANAGER,
Res2.RES_NAME AS RES_MANAGER, Assgn1.ASSN_UID, Assgn1.TASK_UID, Assgn1.TASK_NAME, Assgn1.RES_UID, Res1.RES_NAME,
Assgn1.CREATED_DATE, Assgn1.MOD_DATE
FROM MSP_ASSIGNMENTS_SAVED AS Assgn1
INNER JOIN MSP_PROJECTS AS Proj1 ON Assgn1.PROJ_UID = Proj1.PROJ_UID
INNER JOIN MSP_RESOURCES AS Res1 ON Assgn1.RES_UID = Res1.RES_UID
INNER JOIN MSP_RESOURCES AS Res2 ON Assgn1.WRES_UID_MANAGER = Res2.RES_UID
INNER JOIN MSP_RESOURCES AS Res3 ON Proj1.WRES_UID = Res3.RES_UID
WHERE
(NOT EXISTS (SELECT 1 AS Expr1 FROM MSP_TASKS_SAVED AS Task1 WHERE (TASK_UID = Assgn1.TASK_UID)))
Подключение к MS Project Server или Грабли — не роскошь