title: Dynamic Aliases in the SQL statement
body: <p>I want to display Alias name based on the value of some other column name in the query in SQL Server.  For e.g. </p>
  
  <pre><code>SELECT P.Amount AS (CASE P.Type WHEN 'Individual' THEN 'Salary' ELSE 'Profit' END)
    FROM Person P
  </code></pre>
  
  <p>I know the above is not right, but something like this will help.</p>