SELECT x.projecttitle, x.ProjectID, x.salesrepid, 30 AS dspDaysInactive, x.lastUpdate AS MaxDate
FROM(
SELECT p.projecttitle, p.ProjectID, p.salesrepid, 30 AS dspDaysInactive, max(ul.lastUpdate)lastUpdate
FROM tbl_RD_Projects p
INNER JOIN tbl_PRJ_UpdateLog ul ON (p.projectid = ul.projectid)
WHERE p.OwnerID =
AND p.OwnerType =
AND p.projectStatus = 4
GROUP BY p.ProjectID, p.salesrepid, p.projecttitle
)AS x
WHERE month(x.lastUpdate) = #variables.InactiveDateMonth#
AND day(x.lastUpdate) = #variables.InactiveDateDay#
AND year(x.lastUpdate) = #variables.InactiveDateYear#
UPDATE tbl_RD_Projects
SET projectStatus =
WHERE OwnerID =
AND OwnerType =
AND ProjectID =