MS SQL 2005: Any way to temporarily set the system date for a T-SQL script to a different date?

Question

We have a bunch of T-SQL scripts dependent on today's date and when they run. If one doesn't run on the week it should, we end up temporarily setting the system time a day before, run the script, then set it back.

Is there anyway to temporarily set the system date for a script without changing the original script, like when you execute it or only for that session?

Answer 1

You could store the actual date in a table / temp table. THen retrieve or update that date rather then making a call to GetDate().