title: SQL Retrieve First Matching row
body: <p>I have a database which has two tables. A <code>Call_Info</code> table which holds details about incoming / outgoing calls and has a unique ID named <code>Call_ID</code>. I have a second table which is linked and called the <code>After_Call_Work</code> table.</p>
  
  <p>Each call will have only one After Call Work Record. The dataset is a bit messed up and for the same call there are occasionaly 3 or 4 after call work records. How can I when doing queries just retrieve the earliest After Call Work Record for that particular call ignoring the rest? I imagined using SQL function First_Value but it doesn't seem to be the right one.</p>
  
  <p>Using Microsoft SQL Server 2012.</p>
  
  <p>Any ideas?</p>