Dynamically created a table name in a make-a-table query 1

[LonnieJohnson]

I would like to make part of the name of a make a table query be the current date.

Something like so...

SELECT * INTO MYTABLE + GETDATE()
FROM MASTERFILE

I've tried a couple of combinations and have failed.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[snag56]

declare @sql varchar(255)

set @sql = 'SELECT * INTO MYTABLE' + convert(char(4),DATEPART ( yyyy , GETDATE() )) +
RIGHT('00'+convert(varchar(4),DATEPART ( mm , GETDATE() )),2) +
RIGHT('00'+convert(varchar(4),DATEPART ( dd , GETDATE() )),2) +
' FROM MASTERFILE'

exec @sql

 

[bdreed35]

just to simplify snag's solution:

declare @sql varchar(255)

set @sql = 'SELECT * INTO MYTABLE' + convert(char(8),getdate(),112) + ' FROM MASTERFILE'

exec @sql

~Brian

 

[LonnieJohnson]

That's cool guys, but it is telling me that it cannot find the stored procedure 'SELECT * INTO MYTABLE20040405 FROM MASTERFILE'

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[JayKusch]

Try This ...

declare @sql_command VarChar(200)

set @sql_command =

'SELECT * INTO MYTABLE' +
CONVERT(Char,GETDATE(),101) + ' FROM MASTERFILE'

exec (@sql_command)

Thanks

J. Kusch

 

[LonnieJohnson]

Thanks guys. Jay the parenthesis did it!

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!