title: define parameters from an Excel Cell for a CASE WHEN in SQL
body: <p>I want to be able to define my parameter SA.FiscalWeek in the below code from a cell in Excel</p>
  
  <pre><code>SUM(CASE WHEN SA.FISCALYEAR = 2017 
  AND SA.FISCALWEEK = 19 THEN SA.SALESEXVAT/SA.EXCHANGERATEEURO END ) AS 'Week'
  </code></pre>
  
  <p>I will be using multiple <code>Case When</code> in my overall code all with individual parameters</p>
  
  <p>I have found a way this is possible using a <code>WHERE</code> statement, </p>
  
  <p>But was wondering if it is possible in a <code>CASE WHEN</code> statement ?</p>