title: select subquery inside then of case when statement?
body: <p>Is there a way to run a select statement from a "then" in the sql server case/when statement? (I need to run subqueries from a then statement.)  I cannot have it in the where statement. </p>
  
  <pre><code>select 
    case @Group 
      when 6500 then (select top 10 * from Table1)
      when 5450 then (select top 5 * from Table1)
      when 2010 then (select top 3 * from Table1)
      when 2000 then (select top 1 * from Table1)
      else 0 
    end as 'Report'
  </code></pre>