• DaveDB (1/24/2014)


    I completely disagree with the use of cursors. They are heavy and slow and anything that you can do in a cursor you can be accomplished in a loop and/or temp table.

    Dave,

    Changing a cursor to a loop, won't be any better because a cursor is basically a loop.

    Cursor should be used carefully and as last resort as you say. For administrative jobs they're a great tool.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2