Re: Help setting up stored procedure

From: "Plamen Ratchev" <Plamen@xxxxxxxxxxxxx>
Date: Tue, 26 Feb 2008 14:50:40 -0500

Try something like this:

SELECT duedate
FROM Library
WHERE duedate < DATEADD(day, DATEDIFF(day, 0, CURRENT_TIMESTAMP) - 7, 0)

HTH,

Plamen Ratchev
http://www.SQLStudio.com
.

Follow-Ups:
- Re: Help setting up stored procedure
  - From: JJ297

References:
- Help setting up stored procedure
  - From: JJ297

Prev by Date: Help setting up stored procedure
Next by Date: Re: Help setting up stored procedure
Previous by thread: Help setting up stored procedure
Next by thread: Re: Help setting up stored procedure
Index(es):
- Date
- Thread