title: SQL Server 2008 - update a field if date is older than 60 days
body: <p>I have three fields in my user_Group table: Banner_flag, warning_Date1 &amp; warning_Date2</p>
  
  <p>What i want to do is update warning_Date2 to today's date &amp; also set banner_flag to = '2' if the date in warning_Date1 is over 60 days old and do nothing to those that don't meet this criteria. </p>
  
  <p>I'm pretty sure I need a case statment but am having trouble writing it effectively. Any help appreciated, thanks.</p>