title: CTE within a CTE
body: <p>Is it possible to write a CTE within a CTE?</p>
  
  <p>I want it to follow this logic, but the interpreter doesn't like this code.</p>
  
  <pre><code>with outertest as(
  
      with test as (
          select 
              SRnum, 
              gamenumber, 
              StartOfDistribution, 
              ApplicationNumber   
          from #main
          where startofdistribution = '2011-06-14 00:00:00.000'
          and SRnum = '313'
          --order by SRnum, gamenumber, StartOfDistribution, ApplicationNumber
      )
      select
          ApplicationNumber
          ,count(*) as RetailerAppearance
      from test
      group by ApplicationNumber
      having count(*) = 4
  
  ) select count(*) from outertest
  </code></pre>