Ну например расширяя тот пример, который только что предоставили мен в соседнем топике:

USE pubs
GO
/* Create a procedure with a cursor output parameter. */
CREATE PROCEDURE OpenCrsr2
@OutCrsr CURSOR VARYING OUTPUT,
@OutCrsr2 CURSOR VARYING OUTPUT
AS
SET @OutCrsr = CURSOR FOR
SELECT au_lname
FROM authors
WHERE au_lname LIKE 'S%'

OPEN @OutCrsr

SET @OutCrsr2 = CURSOR FOR
SELECT au_lname
FROM authors
WHERE au_lname LIKE 'S%'

OPEN @OutCrsr2
GO

/* Allocate a cursor variable. */
DECLARE @CrsrVar CURSOR
DECLARE @CrsrVar2 CURSOR

/* Execute the procedure created earlier to fill
the variable. */
EXEC OpenCrsr2 @OutCrsr = @CrsrVar OUTPUT, @OutCrsr2 = @CrsrVar2 OUTPUT

/* Use the variable to fetch the rows from the cursor. */
FETCH NEXT FROM @CrsrVar
WHILE (@@FETCH_STATUS <> -1)
BEGIN
FETCH NEXT FROM @CrsrVar
END

/* Use the variable to fetch the rows from the cursor. */
FETCH NEXT FROM @CrsrVar2
WHILE (@@FETCH_STATUS <> -1)
BEGIN
FETCH NEXT FROM @CrsrVar2
END

CLOSE @CrsrVar
CLOSE @CrsrVar2

DEALLOCATE @CrsrVar
DEALLOCATE @CrsrVar2
GO

Так пойдет ?