Declare @tbN varchar(100)
set @tbN='TEMP'+convert(char(8),getdate(),112)
print @tbN
exec(' create table '+@tbN+'..
..
...
..
....')
set @tbN='TEMP'+convert(char(8),getdate(),112)
print @tbN
exec(' create table '+@tbN+'..
..
...
..
....')
set @tbN='TEMP'+convert(char(8),getdate(),112)
print @tbN
exec(' create table '+@tbN+'..
..
...
..
....')