• Thank you so much,

    The dilemma I am facing is that job is averaging 21 hours and it is scheduled for everyday, so the job pretty much keeps running all day. And it happens to be an important job that I cannot just stop to test few things. Also when I am testing the old code(one with cursors), just the select statement is taking up a lot of time and making the whole server slow...How should I proceed If I want to test your new code?

    Also since we took out cursors in step 1, would it matter If I kept the cursors on step 2?

    Thanks again.