Jul 31 2008, 02:02 AM
I have three queries- each involving subqueries. I have created three cursors- one for each query. But now I am in dilemma of replacing them with single cursor. And my query will be - all the three queries unioned together. please suggest options for me- which is the best approach?
Jul 31 2008, 03:40 AM
Jul 31 2008, 09:06 AM
>> which is the best approach?
Me, I like to replace subqueries with standard joins whenever possible . . . .
I would use UNION with a single cursor.
Afterall, why have additional overhead, if it's not necessary?
Jul 31 2008, 09:42 AM
Let's begin to guess what your code looks like or does. Umm, drawing a blank here. Your question is about the same degree of detail as this:
"My query takes a long time, can anyone help?"
If someone were to ask you that, what would your guess be as to the problem?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here