title: SQL Alias - Limited to just a string?
body: <p>I've looked around and it seems like it is not possible but the question is, when using an Alias for a column name, am i limited to just a string alias? </p>
  
  <p>I have a stored procedure that dumps some data into a temp table which i query later to export a report. </p>
  
  <p>There are a few columns on this temp table that represent data from specific weeks and it would be helpful to have the date of the week as the column name, but i can't seem to be able to do that using the date variable used in the stored procedure (@dt).</p>
  
  <p>I can do this manipulation of the column names in the application and achieve the same result, but it would be cleaner if i could keep this type of logic in the stored procedure instead of spreading it between the DB and the application.</p>
  
  <p>Example:</p>
  
  <pre><code>declare @myname varchar(10)
  set @myname = 'My Name'
  SELECT FirstName AS '@myname'
  FROM User
  WHERE LastName = 'Smith'
  </code></pre>
  
  <p>Thanks</p>