homebrew01 (8/2/2011)
I have a need to pre-populate a list of the 5th business day each month. Any idea how to do that ? :hehe:
WITH CTE ( dt, rn )
As (
SELECT
dt
, ROW_NUMBER() OVER ( ORDER BY dt ) AS rn
FROM
dbo.Calendar
WHERE
Y = YEAR(GETDATE())
AND M = MONTH(GETDATE())
AND IsBusDay = 1
)
SELECT
'RUN SUBSCRIPTIONS'
FROM
CTE
WHERE
rn = 5
AND dt = DATEADD(D , 0 , DATEDIFF(D , 0 , GETDATE()))
IF @@ROWCOUNT = 1
SELECT 'sp_startjob'
ELSE
SELECT 'NOTHING TO DO'
Script to load my Calendar table.