Posted by sean.gilbertson on 03/10/06 19:48

Hi,

I have a user-defined function which returns a table (call it '@a'),
and has another table defined as a variable (call it '@b'). When I try
to do the following query, I get "Must declare the variable '@b'" and
"Must declare the variable '@a'." How do I remedy this?

The query:

UPDATE @a
SET
stuff =
(SELECT otherStuff From @b
WHERE @b.someID = @a.someID)

• Next in forum: Re: Different query plans for view and view definition statement
• Prev in forum: User-defined function and temporary tables
• Thread view: Syntax of updating table variables?

[Reply to this message]