Joshua, try:
update S
set S.updatedate = getdate()
FROM ovdsave S INNER JOIN ovdtemp T
ON S.sonum = T.SONUM
Then go home and get some sleep :)
Bob
-----Original Message-----
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: May 16, 2001 10:22 AM
To: CF-Talk
Subject: Update Statement
I am tired why is this giving me an error?
update ovdsave
set ovdsave.updatedate = getdate()
where ovdsave.sonum = (SELECT ovdtemp.SONUM
FROM ovdtemp)
and this way also gives me an error:
update ovdsave
set ovdsave.updatedate = getdate()
from (SELECT ovdtemp.SONUM FROM ovdtemp)
where ovdsave.sonum = ovdtemp.sonum
I am running this in a dts package to update ovdsave.updatedate to the
current date if the ovdtemp.sonum = ovdsave.sonum.
Please help so I can go home and sleep.
Joshua Tipton
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
