Afternoon all,
Is it possible from within SQL Server Management Studio to create a table based upon an existing table using the current date as part of the table name
I.E; SELECT * FROM TABLENAME INTO TABLENAMEWITHDATE - if this query was setup as a SSMS Agent Job we could create a daily snapshot of data in this table.
I've tried many times but always get an incorrect syntax message when I try to excecute the query. I'm not sure what syntax I should use to create the tablename with current date included
Any help would be appreciated.
Thanks,
Chris