|
|
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
Navigation:
[Reply to this message]
|