title: Execute the same SQL update statement for a number of tables?
body: <p>Hi I have 6 different tables in sql server that I want to run the following script against. is it possible to do it in some sort of a loop?</p>
  
  <pre><code>UPDATE Table
      SET fk =CASE fk
      WHEN 1 THEN 15
      WHEN 2 THEN 16
      WHEN 3 THEN 17
      WHEN 4 THEN 11
      WHEN 5 THEN 12
      WHEN 6 THEN 13
      WHEN 7 THEN 14
      END
      WHERE fk IN (1,2,3,4,5,6,7) 
      UPDATE Table SET fk = fk - 10
  </code></pre>