title: Efficient SQL query for two updates and search queries
body: <p>I have a query like this:</p>
  
  <pre><code>SELECT TOP 1 ID, DATA, OTHERINF FROM MYTABLE WHERE DATE = @DATE
  </code></pre>
  
  <p>and after reading the row data and using it I want to update that retrieved row and change one of it's columns (in another transaction).</p>
  
  <p>But as you see here i searched for that row twice. Is there any way that I keep remember the row and do the update without searching again.</p>
  
  <p>Thank you.</p>