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...
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
Job Schedule Help with UPDATE
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password