SQLTeam.com | Weblogs | Forums

How to avoid Cursor or looping from T-SQL SP?


#1

I've multiple SP using Cursors and few of these calls another SP also based on some looping conditions. Performance is very low. How can I avoid these cursors?
I do nt want any looping in my code.


#2

Can you use set-based logic, instead of a cursor? (I am assuming that the cursor is processing rows one-by-one).

Might help if you post an example of some code that you want to "improve"