title: SQL Server minimum of all positive values
body: <p>I have a table like this:</p>
  
  <pre><code>tblMembers
  ID   Credit  Is_Member
  ---  ---     --- 
  1    45      True
  2    20      False
  3    25      True
  4    -10     True
  5    -5      False
  6    13      True
  </code></pre>
  
  <p>How can I create a view showing the record with the (Minimum Positive) value of <strong>Credit</strong> and <strong>Is_Member</strong>="True"?</p>