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_PRJ_Projects p with (nolock) INNER JOIN tbl_PRJ_UpdateLog ul with (nolock) 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_PRJ_PROJECTS SET projectStatus = WHERE OwnerID = AND OwnerType = AND ProjectID =

This process has completed