But I'm still curious how you'd rewrite the procedure without using an cursor 🙂

What we do:

Select ID, Adress, Zipcode

From aTable

Open Cursor

Fetch Next into variables

Do while eof

...

I've put the option ARITHABORT ON and now it's as fast as before again...

so issue solved!

Thanx,

/Jan

Hi, did you solve it, because I have the same issue.

I also use a cursor, but that has to stay in the procedure.

When running it from SSMS, it flies, but...

I've managed it by adding a field in the dataset with a row_number() over(order by ...) statement in it.

And then filter on this newly added field, <= 10.

Works fine...

/Jan

Topic can be closed!!!!

I started the wrong procedure !!!!!!:w00t:

Regards,

/Jan