BillQuick project import queries

Below are sample queries that can be used when creating a custom SQL import from BillQuick:

Projects:

SELECT ProjectCode AS ProjectNumber, ProjectName FROM Project
WHERE ProjectPhase IS NULL
AND ProjectStatus IN ('Active', 'Main')

Phases:

SELECT b.ProjectCode AS ParentProject, a.ProjectPhase AS
PhaseNumber, a.ProjectName AS PhaseName From Project a
INNER JOIN
(SELECT ProjectCode FROM Project
WHERE ProjectPhase IS NULL
AND ProjectStatus IN ('Active', 'Main')) b
ON a.ProjectCode= b.ProjectCode
WHERE ProjectPhase IS NOT NULL
AND ProjectStatus IN ('Active', 'Main')