I just finished a stored procedure that needs to run automatically. I wrote it so that I could pass it one parameter- a date. How can I pass the current date to it from the scheduler without hard coding the date into the procedure?
The idea is that it'll run on the date needed but if I want to test it I can pass it any date I want.
Any ideas? this is running on MS SQL 2005.