Posted by Radu on 10/02/96 11:48

Hi. I have a SP named, for instance, SP1.

I need to execute something like

SELECT Sum([Field1]) FROM SP1 WHERE [SP1].[Field1]='0'

and I get the message:

Server: Msg 208, Level 16, State 3, Line 1
Invalid object name 'SP1'.

However, SP1 *IS THERE* and runs fine !!!

Thanks
Alex

• Next in forum: Concatenation getting truncated
• Prev in forum: Re: My boss beats me
• Thread view: What's wrong in this query ?

[Reply to this message]