[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Job Schedule Help with UPDATE

Chamark via WebmasterKB.com

3/30/2007 5:49:00 PM

Newbie using SQL 2000 - First Job Schedule is failing - Need help. When I run
this UPDATE query from the Table query pane I get this error message and when
I click OK the query runs just fine. And the error doesn't come up again
while I am in that session, only the first time I try to run the update.

Error
"The Query Designer does not support the Optional FROM clause SQL construct."

I want to schedule this, so in my only step in Job Scheduler I use the same
query but it always fails. Is it because of the one time error? If so how do
I get around that, and if not what am I doing wrong?

Thanks in advance for your help. See UPDATE statement below

UPDATE [dbo].[CM]
SET Manager = Team
FROM [National Call Stats], CM
WHERE [Rep Ssn] = AssocID AND [Date] = CallDate AND (CallDate >= DATEADD
(mm, DATEDIFF(mm, 0, GETDATE()), 0))

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programmin...