title: How can I SELECT multiple columns within a CASE WHEN on SQL Server?
body: <p>I have searched this site extensively but cannot find a solution.</p>
  
  <p>Here is the example of my query:</p>
  
  <pre><code>SELECT 
     ActivityID,
  
     Hours = (CASE 
                  WHEN ActivityTypeID &lt;&gt; 2 THEN
                       FieldName = (Some Aggregate Sub Query),
                       FieldName2 = (Some other aggregate sub query)
                  WHEN ActivityTypeID = 2 THEN
                       FieldName = (Some Aggregate Sub Query with diff result),
                       FieldName2 = (Some Other Aggregate Sub Query with diff result)
             END)
  </code></pre>
  
  <p>obviously I'm leaving out a lot of the query, I just wanted to see if it's possible.</p>
  
  <p>I know I probably could just do the "CASE" twice but figured I would ask...</p>