title: How do I select only the latest entry in a table?
body: <p>I have a 3 table SQLServer Database.</p>
  <pre><code>Project
  ProjectID
  ProjectName
  
  Thing
  ThingID
  ThingName
  
  ProjectThingLink
  ProjectID
  ThingID
  CreatedDate
  </code></pre>
  <p>When a Thing is ascribed to a Project an entry is put in the ProjectThingLink table.
  Things can move between Projects. The CreatedDate is used to know which Project a Thing was last moved too.</p>
  <p>I am trying to create a list of all Projects with which Things are currently linked to them, but my brain is failing.</p>
  <p>Is there an easy way of doing this?</p>