Is it possible to creat a local temp table with dynamically generated string as a table name?
It is possible but all subsequent operations on that temp table will have to be written as D-SQL only like:
Exec('create table #temp1(a int); insert #temp1 values(1); select * from #temp1')
Anyway, what is the purpose of creating local temp table with dynamic name?
"The IMPOSSIBLE is often UNTRIED"