Post reply

process records in loop

  • April 28, 2024 at 3:50 pm

    Answer

    #4416378

    Is the data in your sqlToExec column in a format that will work with dynamic sql? It looks like might not be so you will probably need to at least double up the single quotes before you can set a variable to equal the value of the column.

    The advice you were given a few days ago was to try to get a single sqlToExec value to work using dynamic sql. Have you done this?  Once this works you can use your loop or cursor to iterate row by row or in groups of rows.

  • April 29, 2024 at 2:17 am

    #4416464

    Unblocking stuck 2nd page of this thread...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • April 29, 2024 at 2:28 am

    #4416465

    Hey if you need to hire someone to figure this out for you I am currently available and I would not even charge you an arm and a leg to do it.

  • April 29, 2024 at 12:17 pm

    #4416636

    Thanks for replies.

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply