title: Find what letters are in a group of records in either SQL or SSRS
body: <p>I have the following data (I have a lot more rows this is just an example):</p>
  
  <pre><code>VALUE   Location             FLEET    REGION
  P       Pocatello, ID        104       232
  B       Pocatello, ID        104       232
  B       Spokane, WA          107        232
  B       Spokane, WA          107       232
  </code></pre>
  
  <p>In either reporting services or MSSQL I need to group by fleet. Afer it is grouped I want it to see what values each group contains.</p>
  
  <p>If the group contains values P and B then its Production
  If the group contains B only then it is Reporting
  If the group contains P then its Productivity</p>
  
  <p>What I want from this example is the following rows to be returned in the end.</p>
  
  <pre><code>VALUE         LOCATION           FLEET    REGION
  Production     Pocatello,ID       104       232
  Reporting      Spokane, WAS       107       232
  </code></pre>
  
  <p>Right now the SQL query reports the data at the top of my quesiton. I need to either do the grouping and calculation is MSSQL or SSRS either one will work but how do I go about doing it to get the data listed like I have right above.</p>
  
  <p>Thanks!</p>