title: How to SELECT * into a SQL table incremntally by date?
body: <p>I have a SQL Server table called "tblProducts".</p>
  
  <p>Sometimes I backup this table by making a copy of it with this simple query:</p>
  
  <pre><code>SELECT *
  INTO [test01].[dbo].[tblProducts_20141206]
  FROM [test01].[dbo].[tblProducts]
  </code></pre>
  
  <p>Every time when making a backup, the date is included in the table name.</p>
  
  <p>I would like to create a SQL Job that runs this kind of query once every week.</p>
  
  <p>Is it possible to maybe in a stored procedure or declaring a variable to achieve this that allows the backed-up table name to be named like [tblProducts_todaysDate]?</p>
  
  <p>Thanks.</p>