Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-12 : 07:45:33
|
| David writes "I need to put this a query into a DTS packet and run on a daily basis. That part I can do, but I can't quite figure out the syntax I want to execute a stored procedure with a date parameter of Current date -1. Please let me know how this can be done. Thanks in advance for your help.windows 2000sql server 2000 Current SPDECLARE @RC intDECLARE @start_date datetime-- Set parameter valuesEXEC @RC = [KAEnterprise].[dbo].[sp_POPULATE_AGENT_REVIEW_RESULTS] @start_date" |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2004-03-12 : 07:58:59
|
| Why do u want to send the date as a parameter, if the date is current date. In the stored procedure u can use getdate(), to get the current date.regardsSachin |
 |
|
|
|
|
|
Stored Procedure with date parameter question