Re: Help setting up stored procedure
- From: JJ297 <nc297@xxxxxxxxx>
- Date: Tue, 26 Feb 2008 12:04:11 -0800 (PST)
On Feb 26, 2:50 pm, "Plamen Ratchev" <Pla...@xxxxxxxxxxxxx> wrote:
Try something like this:
SELECT duedate
FROM Library
WHERE duedate < DATEADD(day, DATEDIFF(day, 0, CURRENT_TIMESTAMP) - 7, 0)
HTH,
Plamen Ratchevhttp://www.SQLStudio.com
Pefect...Thanks!
.
- References:
- Help setting up stored procedure
- From: JJ297
- Re: Help setting up stored procedure
- From: Plamen Ratchev
- Help setting up stored procedure
- Prev by Date: Re: Help setting up stored procedure
- Next by Date: Problem with a lot of inserts in short time - SQL Server 2000
- Previous by thread: Re: Help setting up stored procedure
- Next by thread: Problem with a lot of inserts in short time - SQL Server 2000
- Index(es):
