[EMAIL PROTECTED] (Dawn) writes:
> I have a sql update statement that is dealing with hundreds of
> thousands of records. It takes hours and hours to complete (if it
> does complete and not take down the server).
No wonder, if you write it like that. You're forcing a fresh select
from gl_totals
I have a sql update statement that is dealing with hundreds of
thousands of records. It takes hours and hours to complete (if it
does complete and not take down the server). Here is how I have it
right now:
update aud_member_ext_attributes b
set EXTVALUE217 =
(select a.MTD
from
