title: sql server dynamic calculated field
body: <p>I need a calculated field based on each record in sql server 2000. 
  for example there is  a table like this:</p>
  
  <pre><code>col1 col2 calcfield
  -------------------
  1     2   col1+col2
  3     5   col1*col2
  </code></pre>
  
  <p>I need a query to calculate the last field per record eg:</p>
  
  <pre><code>1     2     3
  3     5     15
  </code></pre>
  
  <p>Actually This is a system that calculates a number for some persons.There are some parameters stored in fields of a table and there is another field that stores how to calculate the number from those parameters(that is the formula). for each person there are different parameters and a different formula. I want to design a query that can extract parameters and the calculated column directly from the table</p>
  
  <p>Is there any way to do this and if there is what is the best and fastest way....</p>
  
  <p>best regards</p>