Home Forums SQL Server 2005 T-SQL (SS2K5) Cursor and update RE: Cursor and update

  • January 24, 2014 at 8:55 am

    #1683159

    ChrisM@Work (1/24/2014)

    phineas629 (1/24/2014)

    ... I am required to use the cursor...

    Perfectly reasonable so long as this is homework.

    It shouldn't be homework as I recognize this from a previous thread http://www.sqlservercentral.com/Forums/Topic1532233-338-1.aspx

    You should try to get rid of the cursor. Even if this will be used only for a small set of rows, you might need to work with larger sets in the future and cursors will become a performance issue.

    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