Date Stored Procedure

[GuyInTn]

Hi all,

I am trying to write a stored procedure that will delete records in a
table that are older then 30 days. I am checking against a field that
is called PositionDate. Can someone point me in the right direction?

TIA

[David Portas]

DELETE
FROM Sometable
WHERE positiondate < DATEADD(D,-30,CURRENT_TIMESTAMP)

--
David Portas
------------
Please reply only to the newsgroup
--

[GuyInTn]

Thanks that works great. My next newbie question is, is there a way to
have the SQL server run this automatically once a day?

On Mon, 8 Dec 2003 21:04:46 -0000, "David Portas"
<RE****************************@acm.org> wrote:

DELETE
FROM Sometable
WHERE positiondate < DATEADD(D,-30,CURRENT_TIMESTAMP)

--
David Portas
------------
Please reply only to the newsgroup

[David Portas]

Yes, you can create and schedule a job:

http://msdn.microsoft.com/library/en...omate_42r7.asp

--
David Portas
------------
Please reply only to the newsgroup
--

[GuyInTn]

Thanks for the link. It was very helpful!

On Mon, 8 Dec 2003 22:17:00 -0000, "David Portas"
<RE****************************@acm.org> wrote:

Yes, you can create and schedule a job:

http://msdn.microsoft.com/library/en...omate_42r7.asp

--
David Portas
------------
Please reply only to the newsgroup