title: Use value of a column for another column (SQL Server)?
body: <p>lets say I have a huge select on a certain table. One value for a column is calculated with complex logc and its called <em>ColumnA</em>. Now, for another column, I need the value from <em>ColumnA</em> and add some other static value to it. </p>
  
  <p>Sample SQL:</p>
  
  <pre><code>select table.id, table.number, complex stuff [ColumnA], [ColumnA] + 10 .. from table ...
  </code></pre>
  
  <p>The <em>[ColumnA] + 10</em> is what im looking for. The complex stuff is a huge case/when block.</p>
  
  <p>Ideas?</p>