title: How to generate table name by datetime?
body: <p>I realize this is syntactically bad but I figure it somewhat explains what I'm trying to do. Essentially, I have a batch job that is going to run each morning on a small table and as a part of the spec I need to create a backup prior to each load that can be accessed by a report.</p>
  
  <p>What I have so far is:</p>
  
  <pre><code>select  *
  into    report_temp.MSK_Traffic_Backup_ + getdate()
  from    property.door_traffic
  </code></pre>
  
  <p>How can I make this function or should I consider doing this a better way?</p>