title: I need to pass column names using variable in select statement in Store Procedure but i cannot use dynamic query
body: <p>Here is my SQL query below. I want to select values from the column names given as variables. Is there any appropriate way of doing this except using a dynamic query?</p>
  
  <pre><code>SELECT EPV.EmployeeCode, @RateOfEmployee, @RateOfEmployer
  FROM [HR_EmployeeProvisions] EPV
  </code></pre>