May 13, 2010 at 12:55 am
Hi guys, ive been working with a simple update statement which ran sucessfully, but then began thowing an error each time executed. Msg 8624, Level 16, State 116, Line 1
Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services. After reading up on it at http://support.microsoft.com/kb/931329 it claims to be a bug. What doesnt make sense is that it ran perfectly before, something else may be happening here. The query im running isUPDATE
I
SET
DropTrans = 1
FROM
ImportPrep I (NOLOCK)
JOIN UniverseWarehouse_TFC.dbo.[Transaction] Tr (NOLOCK) ON Tr.AccountId = I.AccountID
WHERE
(DATEDIFF(dd, I.TransactionDate, Tr.TransactionDate) = 0) AND
I.DtCode = Tr.DTCode AND
I.Details = Tr.Details
The ImportPrep table was a temp table which i changed to physical one, simply to see if that had any sort of impact, but the issue remains. I cant believe that this sort of error would happen out of the blue when it was running perfectly before. SQL version im running on is: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Thanx in advance.
May 13, 2010 at 4:02 am
See if this helps
May 17, 2010 at 12:43 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply