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)

[Back to original message]