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