Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    51

    Unanswered: Use a cursor as a temporary table

    Is it possible to merge two or more cusors within the scope of a stored procedure?

    That is, can we declare cursors, open them and then 'select' from them into a third cursor that is returned to the client?

    Thanks,

    Kimball Johnson

  2. #2
    Join Date
    Jan 2005
    Posts
    191
    If the columns selected from the two cursors are compatible then use one cursor with UNION ALL between the selects.

    If they are incompatible what do you expect the user to see???? You'll have to use 2 result sets.

    James Campbell

Posting Permissions

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