B
Bev
I am receiving this error when running the following query:
UPDATE [T1001 Claims] INNER JOIN CLMPRDFIL_RCPDTP ON ([T1001 Claims].DQOINB
= CLMPRDFIL_RCPDTP.E0OINB) AND ([T1001 Claims].DQP2NB =
CLMPRDFIL_RCPDTP.E0P2NB) SET [T1001 Claims].[Claim Cost] =
([E0ERPR]+[E0ESPR]);
It occurs within 10 minutes of starting. T1001 Claims table has 24,587
records. CLMPRDFIL_RCPDTP has 32,904,317. I am linked to CLMPRDFIL_RCPDTP
thru an ODBC driver. My temp file is located on my C: drive which has 95.2 GB
of free space.
I am stumped and hope to find a better way to build this query.
Thank you in advance.
UPDATE [T1001 Claims] INNER JOIN CLMPRDFIL_RCPDTP ON ([T1001 Claims].DQOINB
= CLMPRDFIL_RCPDTP.E0OINB) AND ([T1001 Claims].DQP2NB =
CLMPRDFIL_RCPDTP.E0P2NB) SET [T1001 Claims].[Claim Cost] =
([E0ERPR]+[E0ESPR]);
It occurs within 10 minutes of starting. T1001 Claims table has 24,587
records. CLMPRDFIL_RCPDTP has 32,904,317. I am linked to CLMPRDFIL_RCPDTP
thru an ODBC driver. My temp file is located on my C: drive which has 95.2 GB
of free space.
I am stumped and hope to find a better way to build this query.
Thank you in advance.