title: how to add multiple columns to a group by case?
body: <p>I have the following group by clause on my query which uses a case statement but I want to add another column to the group by too:</p>
  
  <pre><code>        group by case @dateType
  
  WHEN 'Daily' then i.overridedate
  WHEN 'Weekly' then dateadd(day,-1*datepart(weekday,i.overridedate)+1,i.overridedate) 
  WHEN 'Monthly' THEN DATEADD(day, -1*DATEpart(day,i.overridedate)+1, i.overridedate) 
  WHEN 'Quarterly' THEN dateadd(mm,-3,DATEADD(qq, DATEDIFF(qq,0,i.overridedate )+1, 0)) END
  </code></pre>
  
  <p>how do I add another column to this group by?</p>