Simple example. You have a parent child relationship in your data that has a ragged child hierarchy. You need to use different logic on different types of parent records and...

Nothing wrong with cursors they have their place and are very useful.

Oracle use both set based and cursor base queries - both are very fast - not sure why Microsoft...

Did you find out what is causing this - as I have exactly the same problem.

Cheers

Andrew