salut, revin cu o intrebare

de ce daca rulez:

set @strSQL='select * from TempTable order by startTime'
exec sp_executesql @strSQL

imi afiseaza tot ce contine tabela respectiva

iar daca vreau sa rulez astfel:

set @strSQL='select * from '+@gTemp_table+' order by startTime'
exec sp_executesql @strSQL

nu-mi afiseaza nimic dar imi spune

The command(s) completed successfully.

cum pot afisa ce contine respectiva tabela daca ea este o variabila locala

multumesc