I want a daily copy, that I need to save, of a specific table. Something like:
============
declare @sql nvarchar(8000), @d datetime
set @d = getdate()
set @sql='MyTable' + CONVERT(VARCHAR,@d,112)
select * into @sql
from MyTable
===========
Is this possible?
Kent J.