title: How would I calculate interest daily in SQL Server 2008 using a Stored Procedure?
body: <p>Basically, I want to take my current Account.Balance and calculate interest once daily, based on the rate defined as Account.InterestRate.</p>
  
  <p>I have table "Account" with (relevant columns) "InterestRate" and "Balance". I need to have a job run nightly (@ midnight?) that calculates the Balance field based on the current value of Balance and the InterestRate.</p>
  
  <p>How might I go about doing this?</p>