Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Hanging WHILE loop RE: Hanging WHILE loop

  • May 11, 2014 at 11:10 am

    #1712489

    Your query looks just like mine but using a while loop instead of a single operation. Why would you do that.

    Without DDL and sample data, I can't be sure why are you using those triggers. I can only be sure about one thing, you don't need 2 as they can be part of the same trigger.

    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