Creating a Trigger based on a date

• cmclaugh

  Newbie

  Points: 1

  More actions

  July 8, 2002 at 11:38 am

  #158114

  I am wanting to create a trigger that will copy data from table to another(based on the age of the data against its timestamp' ie 10 days old) and then delete it from its original table. Any ideas, thanks!

• danw

  SSCommitted

  Points: 1842

  More actions

  July 9, 2002 at 9:25 am

  #432255

  Well you should probably plan this out a bit...

  How many rows are you expecting in the table?

  What type of activity is expected? Ex. 10% Insert, 20% Update, 70% Select.

  At what point do you want the record to be copied over... Insert, Update, Both?

  When the trigger fires do you want to handle just the records modified or all the records that fit the criteria within the table?

  Could this be handled with a nightly or hourly job instead?

  Once you can answer these questions then we'll be able to come up with a good solution.