trigger by date

[ching0418]

Is it possible to have an update in the database triggered by the date?

What I want to do is to set a data of one column back to 1 when the year changes.

For example:
Today is Dec 31, 2005
Series values is 853

By tomorrow, January 1, 2006, the series value should be 1.

please help....thanks in advance

 

[dbomrrsm]

use DTS and set up an update job to run on 1 January every year that does your update.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[miq]

HI,
setup a simple scheduled job that that runs yearly and incorporte desired update code in it.

B.R,
miq