March 4, 2020 at 9:05 pm
I wasn't sure if running this package weekly if that function would update automatically every week
GETDATE() updates every time you call it.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 4, 2020 at 9:09 pm
So my scheduled job is set for every monday at 7am for that location so you are saying everytime the job is executed it will update to the current week.
March 4, 2020 at 9:23 pm
The date which appears in your subject will depend entirely on the date on which the job is run. In words: "Give me the date for Sunday of the preceding week."
Note: as far as SQL Server is concerned, weeks begin on Mondays.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply