title: How to get Column data by sub grouping
body: <p>I m trying to get the Status percentage by different status wise and we have 4 types of status.
  Here is the data for Columns below.</p>
  
  <pre><code>MR_ID Sup_ID    Status
  
  1   1   Rejected    
  1   1   Accepted    
  1   1   Accepted    
  1   1   Rejected    
  2   2   InProgress  
  2   2   InProgress  
  2   2   Accepted    
  2   2   Fordwarded  
  </code></pre>
  
  <p>Like for MR_ID:1 and Sup_ID:1 combination the % of "Accepted" is 50% and  % of "Rejected" is 50%</p>
  
  <p>Need to write a sql query or Stored Procedure to find it out in sql server</p>
  
  <p>Not getting any clue.</p>