• It's highly likely that the folks here can replace your cursor-based code with a fast, efficient and pretty set-based equivalent - why don't you post your code and let them try? There's a good reason for this. If you are experiencing locking/blocking problems with a slow loop-based process then replacing it with a super-fast set-based version will help and may even eliminate the problem.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden