Post reply

get stored procedure to loop through list of variables

  • August 23, 2010 at 3:07 pm

    #1210706

    It's missing the FROM clause

    SELECT @currClientID = ClientID FROM <your tb name> WHERE RowNum = @currRowNum

    I didn't add the FROM clause because I didn't know what it was.

    Hope this helps.

  • August 23, 2010 at 3:18 pm

    #1210710

    DOH!:(

  • August 23, 2010 at 3:30 pm

    #1210716

    awesome, that worked.

    now i got one little hurdle, probably something in the pro, but each clients results are put into a little result table of it's own. I guess I need to output the results to another temp table, so I get get it all in one?

    thanks again!

  • August 23, 2010 at 3:43 pm

    #1210721

    Yup, you should put them all in a temp table so you can insert/update the result table all at once.

    FYI,

    Since my suggesting of while-loops, I ran across a few articles saying that most issues with cursors have been addressed. (you have to use the correct options. eg. FAST_FORWARD)

    Of course, a few articles that say otherwise as well.

    Glad you got both cursor and while loops to work!

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

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