hello, Besides fixing the code, I need a short-term solution or workaround on how to optimize a cpu intensive query. I have a mutliprocessor 64-bit sql cluster with 56GB allocated to the instance. I've identified the process with the high cpu usage, now I need some tips on how to perhaps make it perform faster. Is there anything like allocating more memory, or processor, or bumping up resources for this particular query? Need info asap. THX!