The query processor could not produce a query plan??

[orangefluffy]

Hi All,

I am getting the following error in SQL 2000.
Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information.

My query gets way too long, maybe in-efficient and now, it's giving me an error.

---- Here is the background detail. ----
table: tblNodeApp [nodeAppID, nodeID, appID]
Users select nodeIDs (nodeID 203, 95, and 91) in this case.

* nodeid 203 can have value appid 1, 2, 3, 4, 5
* nodeid 95 can have value appid 3, 4, 5
* nodeid 91 can have value appid 1, 2, 3

The result should be appid 3. application 3 is intalled on all three nodeid(servers). I want to list applications that are mutual/common to the selected NodeIds (servers).

select appid from tblNodeApp
where nodeId = 203 and
appid in (select appid from tblNodeApp where nodeId = 95) and
na.appid in (select appid from tblNodeApp where nodeId = 91)
--------------

When users select numerous nodeIDs (could be 120+ nodeIDs), I get this error. Otherwise, it works fine.Is there another way to get the result I want?

Thank you very much in advance.

 

[elsenorjose]

You should post this in the SQL forum. This is an ANSI SQL board. Thanks.

 

[gmmastros]

I agree about posting in the sql forum. I would also recommend that you update your sql instance to at least service pack 3a. Do a google search for 'sql service pack download'.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[orangefluffy]

sorry. first time posting here. I don't see a sql forum.

btw, my sql server has sp4

 

[r937]

forum183

r937.com | rudy.ca