title: Remove Adjustment Rows SQL Select Statment
body: <p>I would like to remove adjustment rows from my SQL select query. Here is what I have right now:</p>
  
  <pre><code>Resource    Date    Leave       Position    Hours   Code
  33333   26/02/2016  Sick Leave  TRNSPLNR    -7      SICK                     
  33333   26/02/2016  Sick Leave  TRNSPLNR     7      SICK                     
  33333   26/02/2016  Vacation    TRNSPLNR     7      VAC 
  </code></pre>
  
  <p>This is what the end result should be:</p>
  
  <pre><code>Resource Date       Leave     Position   Hours  Code                   
  33333    26/02/2016 Vacation  TRNSPLNR    7     VAC 
  </code></pre>