title: SQL Server 2008 - Updating only a specific number of rows within a table
body: <p>I have a table called mytable with a number of columns. <br>What I am trying to do is to update a column within that table where 2 colums are matched but only for the first 400 records that match the criteria.</p>
  
  <p>Example:</p>
  
  <p>Columns</p>
  
  <pre><code>Name     Ref   ID    Text
  </code></pre>
  
  <p>When ref = 555 and id = 7 I want to update the column called Text with the word 'Matched'. <br>I am aware that there will be approx 800 records that match the criteria but I only want to update the first 400.<br>
  Can anyone help with this please?</p>
  
  <p>Regards,
  Will.</p>