Posted by Erland Sommarskog on 06/16/05 00:24

Matt (gg@tolton.com) writes:
> The reason I'm using temporary tables is that I have to use EXEC to
> execute the select statement, so the inserted and deleted tables aren't
> available, but temporary tables are. Can I reference a table variable
> like that (in an EXEC statement)? I didn't think that I could.

That's correct. I was sort of suggesting that you would abandon the
dynamic SQL as well.

> I am going to stick with this solution until performance on it becomes
> an issue, at which point I'll be forced to do as you say. Thankyou for
> the advice.

That's a little funny, since in your first post, you complained that
the current scheme was ineffecient.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]