<div>
yes, dynamic sql would be the way<br />

<pre><code id="code-8225428">DECLARE @yyyymmdd nvarchar(8)
SET @yyyymmdd = convert(varchar(8),getdate(),112) 

DECLARE @SQL nvarchar(1000)

SET @SQL = ' SELECT * 
INTO TRP.Cap_Data_' + @yyyymmdd + '
FROM TRP.Cap_Data '
exec(@sql)</code></pre>
</div>


yes, dynamic sql would be the way


DECLARE @yyyymmdd nvarchar(8)
SET @yyyymmdd = convert(varchar(8),getdate(),112) 

DECLARE @SQL nvarchar(1000)

SET @SQL = ' SELECT * 
INTO TRP.Cap_Data_' + @yyyymmdd + '
FROM TRP.Cap_Data '
exec(@sql)

<div>
That's awesome! One more thing, what do I do if I need to add the time to the end of the table name?<br />
<br />
i.e. 20111007_1525
</div>


That's awesome! One more thing, what do I do if I need to add the time to the end of the table name?

i.e. 20111007_1525

<div>
<div class="content wysiwyg-content">
In this statement, I have to manually change the date of the table name everytime when I want to run this code:<br />
<br />
&nbsp;<br />
SELECT * <br />
INTO TRP.Cap_Data_20111007<br />
FROM TRP.Cap_Data<br />
<br />
Instead of manually changing it, can I do something like this?<br />
<br />
DECLARE @yyyymmdd nvarchar(8)<br />
SET @yyyymmdd = convert(varchar(8),getdate<wbr />(),112) <br />
&nbsp;<br />
SELECT * <br />
INTO TRP.Cap_Data_ &amp;&nbsp;'@yyyymmdd'<br />
FROM TRP.Cap_Data<br />
<br />
I'm not sure if there's a way to do this, but I'm not able to figure out how to. Please help.
</div>
</div>


In this statement, I have to manually change the date of the table name everytime when I want to run this code:

 
SELECT * 
INTO TRP.Cap_Data_20111007
FROM TRP.Cap_Data

Instead of manually changing it, can I do something like this?

DECLARE @yyyymmdd nvarchar(8)
SET @yyyymmdd = convert(varchar(8),getdate(),112) 
 
SELECT * 
INTO TRP.Cap_Data_ & '@yyyymmdd'
FROM TRP.Cap_Data

I'm not sure if there's a way to do this, but I'm not able to figure out how to. Please help.

SQL - concatenated table name

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.