title: Trigger to update record when Value = GETDATE()
body: <p>my experience with triggers is that it does something after an update,insert or delete. But is it possible to create a trigger to update a record automatically when its date is today? for example, I have a table with 4 columns.</p>
  
  <pre><code>   StartDate         EndDate         Active          Expired 
  ---------------------------------------------------------------
     2013-01-03      2013-01-05          True           False
  </code></pre>
  
  <p>this is one record, what i want is to create a trigger that will update the <code>Active</code> column to <code>False</code> and <code>Expired</code> to <code>True</code> of this record when its <code>EndDate</code> is = today's date (GETDATE()). How do i do this?</p>