declare @t varchar(20),@sql varchar(1000)
set @t='P_'+convert(varchar(6),getdate(),112)
set @sql=''
set @sql=@sql+'select * into '+@t+' from A'
exec (@sql)
declare @t varchar(20),@sql varchar(1000)
set @t='P_'+convert(varchar(6),getdate(),112)
set @sql=''
set @sql=@sql+'insert '+@t+' select * from A'
exec (@sql)