title: Crosstab query with count of values in SQL Server 2008 R2
body: <p>I've searched and am not finding (or understanding!) how to do what I need to do. I feel a bit silly asking this since there are other examples, but I'm just not getting it....  </p>
  
  <p>Here's the data I have in a view:  </p>
  
  <pre><code>[Approach Status] [Clinic]  
  Approached         GI Med Onc  
  Pending            GI Med Onc  
  Approached         GI Med Onc  
  Not Approached     Breast Med Onc  
  Approached         Breast Med Onc  
  </code></pre>
  
  <p>What I need is:  </p>
  
  <pre><code>[Approach Status] [GI Med Onc] [Breast Med Onc]  
  Approached           2            1  
  Not Approached       0            1  
  Pending              1            0  
  </code></pre>
  
  <p>I've played with modifying code I found on here but....  any help is appreciated!  </p>