title: SQL Server return multiple queries in a single query
body: <p>I have the following table</p>
  
  <pre><code>ID      TYPE        Text       ImagePath     Title    Date
  
   1      Text        Test        NULL          NULL     14/10/2013
   2      Image       NULL        /test/test    NULL     14/10/2013
   3      Title       NULL        NULL          Test     14/10/2013
   4      Text        Test2       NULL          NULL     20/12/2012
  </code></pre>
  
  <p>How can I retrieve ONLY the last 3 (sorted by date) records, 1 with type Text, 1 with type Image and 1 with type Title only? (Basically I only need the type and related field which is not NULL.</p>