Home Forums SQL Server 2008 T-SQL (SS2K8) Why is this code deleting only 1 row at a time instead of using the condition and deleting many rows? RE: Why is this code deleting only 1 row at a time instead of using the condition and deleting many rows?

  • July 18, 2014 at 3:51 pm

    #1730786

    Because the cursor is set to delete one ServiceLogID at a time.

    Even after reading the comments, I'm not sure that it's a good solution, but I don't know the entire story.

    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