title: Update statement to update multiple rows
body: <p>I have a question regarding the following syntax.  Is there a cleaner way to roll this up into one statement rather than two.  I've tried several iterations but this seems to be the only way I can successfully execute these two statements. </p>
  
  <pre><code>UPDATE employee
  SET hire_date = '1979-03-15'
  WHERE emp_id = 'PMA42628M' 
  
  UPDATE employee
  SET hire_date = '1988-12-22'
  where emp_id = 'PSA89086M'; 
  </code></pre>
  
  <p>I tried this as well and I also tried using an AND statement.  Neither worked. Basically I am looking for a less newbie way then the method above, if one exists.  I spent a long time searching and did not find one. </p>
  
  <pre><code>UPDATE employee
  SET hire_date = ('1979-03-15', '1988-12-22')
  WHERE emp_id = ('PMA42628M', 'PSA89086M');
  </code></pre>
  
  <p>Appriciate any advice on this one, and by the way, I am using sql server.
  Thanks</p>