Post reply

Returning a Cursor from a SP

  • June 16, 2003 at 8:04 am

    #81068

    I want to open a cursor and then loop through the cursor executing a sp for a each row updating a column in the cursor with the result form the sp. After looping I want to return the cursor as a record set to my app.

  • June 16, 2003 at 9:12 am

    #461555

    You can create a Temp table (as per your result set) and store the result from cusror into temp table. Select from temp table.

  • June 16, 2003 at 11:58 am

    #461577

    Hello. Based on your post you could take it a step further and create a temporary table instead of a cursor and use a function to assign the appropriate value to the column. When finished select the rows from the temp table.

    Everett



    Everett Wilson
    ewilson10@yahoo.com

Viewing 3 posts - 1 through 2 (of 2 total)

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