Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Dubai
    Posts
    29

    Post Unanswered: fetch results of a cursor to a temporary DB for manipulation

    Hi all

    I want to put the fetch results of a cursor to a temporary DB for manipulation, Im selecting all columns from the table in the cursor and the number of total columns is unknow.


    Please guide me on how this could be done...

    Thanks in advance

    Regards

    Benny

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Get rid of the cursor and use a select into statement with the same query to create a table in the temp database.

    If you want to perform row by row oprerations on the resultset use the identity function to create an identity on it then you can loop through that without need for a cursor.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •