From: Dan Guzman on
To add on to Tom's response, you might consider using table variables
instead of local temp tables (single '#' prefix). Table variables are
handled similarly to local temp tables except that the scope is local to the
module in which is is declared. See the Books Online for more information.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/


"Ralph" <ralphd42(a)hotmail.com> wrote in message
news:8DD1A6D5-A2DE-4578-A4C6-65FD71D3F27E(a)microsoft.com...
> Are there any differences when creating a local temp table using the
> syntax create table #temp
> to create table tempdb..#temp
>
>
> thanks in advance
>
> Ralph
>
>