Hi

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?

Thanks

http://www.catb.org/~esr/faqs/smart-questions.html

>> 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?

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?