ALTER PROCEDURE [z_osumc_update_as_of_date] ( @P_JOB_RUN_ID NUMERIC, @P_JOB_USER_ID NUMERIC ) AS SET NOCOUNT ON; BEGIN UPDATE INV_PROJECTS SET INV_PROJECTS.PRASOF = DATEADD(wk, DATEDIFF(wk, 7,getdate()), 5) FROM INV_PROJECTS P INNER JOIN INV_INVESTMENTS I ON I.ID = P.PRID WHERE I.IS_ACTIVE = 1 AND I.PROGRESS = 1 AND I.STATUS IN (1,5) AND(SELECT DATEPART(WEEKDAY, GETDATE())) NOT IN (1,2,3) UPDATE INV_PROJECTS SET INV_PROJECTS.PRASOF = DATEADD(wk, DATEDIFF(wk, 14,getdate()), 5) FROM INV_PROJECTS P INNER JOIN INV_INVESTMENTS I ON I.ID = P.PRID WHERE I.IS_ACTIVE = 1 AND I.PROGRESS = 1 AND I.STATUS IN (1,5) AND(SELECT DATEPART(WEEKDAY, GETDATE())) IN (1,2,3) END