Posted by M Bourgon on 09/02/06 00:33

> But I agree with David, a permanent table is probably better. Global
> temp tables is a funny invention, and I very rarely find any use for them.

For me, it's mostly a matter of not having to have _another_ random
table that I'll come back to in 5 years and wonder what's going on. We
have a bunch of those already, and I can't reuse one in case they run
simultaneously. The reason it's a global temp table is that so that if
it's running long, I can take a look. (Yes, I know I could do that if
it were a permanent table.)

> Not that I know what you are trying to do, but I have an article on my
> web site that may give you some tips:
> http://www.sommarskog.se/share_data.html.

Thanks, Erland.

• Next in forum: Restore Messed Up Table Names
• Prev in forum: BULK INSERT into table with identity column?
• Thread view: Re: How do you create ##Temp tables if they don't exist, use them if they do?

[Reply to this message]