I split it into multiple UPDATE statements. It's kinda Fox related - I used Fox to generate the script :-)
On 8 March 2013 14:43, Frank Cazabon <[email protected]> wrote: > Can you change to passing in a table of numbers for your IN () section? > Not sure if you can pass a table in to SQL Server using VFP, I've only > ever done that in .NET. Maybe Google Table Valued Parameters and VFP. > > Alternatively CREATE a TEMP table in SQL Server with the numbers and then > join on that? > > Frank. > > Frank Cazabon > > > On 08/03/2013 10:21 AM, Paul Hill wrote: > >> Msg 8623, Level 16, State 1, Line 2 >> The query processor ran out of internal resources and could not produce a >> query plan. This is a rare event and only expected for extremely complex >> queries or queries that reference a very large number of tables or >> partitions. Please simplify the query. If you believe you have received >> this message in error, contact Customer Support Services for more >> information. >> >> Paul: 1 - Microsoft: 0 >> >> :-) >> >> UPDATE tblContacts SET Permanent=1 WHERE Number IN ( >> '1000001','1000002','1000003',**... >> [snip 1000s of lines] >> >> > > ______________________________**_________________ > Post Messages to: [email protected] > Subscription Maintenance: > http://mail.leafe.com/mailman/**listinfo/profox<http://mail.leafe.com/mailman/listinfo/profox> > OT-free version of this list: http://mail.leafe.com/mailman/** > listinfo/profoxtech <http://mail.leafe.com/mailman/listinfo/profoxtech> > Searchable Archive: > http://leafe.com/archives/**search/profox<http://leafe.com/archives/search/profox> > This message: http://leafe.com/archives/**byMID/profox/5139F923.7070403@** > gmail.com<http://leafe.com/archives/byMID/profox/[email protected]> > ** All postings, unless explicitly stated otherwise, are the opinions of > the author, and do not constitute legal or medical advice. This statement > is added to the messages for those lawyers who are too stupid to see the > obvious. > -- Paul --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cadwx0+lw5-tjdx6uckjq6qoysbekgten2epidey42tkh0hh...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
