• It is running the procedure from start to end. The FMTOnly value is set to OFF by default. So your code will run from start to finish. Based on the logic you are using 1 will never = 0, so it will never fall into the loop. Was the intent to have it fall into this loop?

    For better, quicker answers, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/