First, you've to ask youself if you realy need intermidiate temporary tables. You can use result of previous select as derived tables in the following select. If you do need temporay tables, use SQL Server temporary tables

select * into #myTempTable_1 from myCustomer

They're unique for each session even if they have the same name.


>In my SP, i will select some data and put into my cursor.
>select * into myTempTable_1 from myCustomer
>select * into myTempTable_2 from myInvoice.
>
>at the end of the sp ,
>i will drop all temptable.
>
>The problem is .. Does this approach is correct ???
>If there is several people use this store procedure, 1st people drop the
>table, 2dn people start to run that sp, any problem ??