title: Update multiple rows using single value
body: <p>I have a single value of 9/1/2013 for a mailing date. I also have 50 row primary key IDS that need to be updated with this single mail date of 9/1/2013.</p>
  
  <pre><code>    UPDATE    myTable
      SET       MailingDate = CONVERT(DATETIME, '2013-09-01 00:00:00', 102)
      WHERE     (tblID = 1) OR
                (tblID = 2) OR
                (tblID = 3) OR
                (tblID = 4) OR ETC...
  </code></pre>
  
  <p>I have seen some questions about table to table, so i suppose the next question would be. Am i going to be forced to create a tempTable with an ID column and MailDate column and Inner Join it with the actual table I want to update?</p>
  
  <p>Is there way to do this update that doesnt require me have to make my WHERE statement so huge or the whole creating a tempTable way? Any help would be greatly appreciated. </p>
  
  <p>Edit:
  Just adding this, so people have a better understanding why I choose the answer I did.</p>
  
  <p>I get the primary keys through a user selecting rows from a access form datasheet. So the update could be updating anywhere from 1 row to 500 rows(doubt it get that high though, but if it does. Looks like i am stuck creating the temp table). Therfore, I will have a vba string collection of all those ID's which looks like I will need to loop through to create my <code>IN</code> in my SQL statement that I will send to the SQL server.</p>