It's working way faster! My old SQL is so elementary. It's embarrassing.
Thanks Esquared for pointing out George's statement regarding Split. I am new on this forum. I feel a bit lost.
Thank you everyone. It's working and working better now.
Yes, the nodeId list is created dynamically.
I tried ESquared's solution. dbo.Split isn't available in SQL server 2000. I ended up inserting data into a temp table to store the nodeIDs.
=============================================...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.