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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
