title: Join to only the "latest" record with t-sql
body: <p>I've got two tables. Table "B" has a one to many relationship with Table "A", which means that there will be many records in table "B" for one record in table "A".</p>
  
  <p>The records in table "B" are mainly differentiated by a date, I need to produce a resultset that includes the record in table "A" joined with only the <strong>latest</strong> record in table "B". For illustration purpose, here's a sample schema:</p>
  
  <pre><code>Table A
  -------
  ID
  
  Table B
  -------
  ID
  TableAID
  RowDate
  </code></pre>
  
  <p>I'm having trouble formulating the query to give me the resultset I'm looking for any help would be greatly appreciated.</p>