title: SQL Server Reference a Calculated Column
body: <p>I have a select statement with calculated columns and I would like to use the value of one calculated column in another.  Is this possible?  Here is a contrived example to show what I am trying to do.</p>
  
  <pre><code>SELECT [calcval1] = CASE Statement, [calcval2] = [calcval1] * .25
  </code></pre>