Very Computer

Hi,

The way temp tables in MS-SQL works won't resolve some of my problems. What
I would like to be able to do, is something like:

Can that be achieved ? How ?

Thanks
C.Fleury

You have to use EXEC:

Take note though, exec is not optimized and won't run as well as a regular
stored procedure. If its at all possible, I'd try to figure out a way not to
have to use exec.

Zach

[posted and mailed, please reply in news]

Why not? Or more precisely, what are your actual problem? If you present
that, you might be lucky to get a suggestion for a good solution.

One common misconception is that that names of temp tables are not
unique. Of course most SQL developers knows that #tmp behind the
scenes are something else, and one user's #tmp is another user's
#tmp, but I like to mention this just in case.

One common approach when you cannot use temp tables because you access
them from a client and use disconnected record sets, is to have a
permanent table, of which the first key column is a client-key assigned
in some way.

--
Erland Sommarskog, Abaris AB

SQL Server MVP