Below are sample queries that can be used when creating a custom SQL import from Wind2 or Deltek FMS:
Project level:
SELECT CPROJECT AS ProjectNumber, MPROJTITLE AS ProjectName
FROM BMPROJ WHERE Linactive = '0'
Phase level:
SELECT CPHASEID AS PhaseNumber, CPHASEDESC AS PhaseName,
CPROJECT AS ParentProjectNumber
FROM BMPHASE a
INNER JOIN BMPROJ b
ON a.bmproj_id = b.bmproj_id
WHERE a.Linactive = '0'
0 Comments