Getting storedprocedures results into Cursors

hi,

How can i get system stored procedure resultset into cursors.

example:

I want to get sp_validatelogin result set into curosors.

How??????????


thanks
keerthi

The only way I can think of doing something like this is to get the results of sp_validatelogin into a temp table and then declare the cursor on the table.

e.g.

INSERT INTO #MyTemp EXEC('sp_validatelogin')

DECLARE MyTemp_Cursor CURSOR FOR
SELECT ... FROM #MyTemp
...
...
...

You will need to create the temp table before hand with the specific columns that match the output of your stored procedure.

Hope that helps,

Karl

------------
keerthi at 9/5/01 2:42:23 PM

hi,

How can i get system stored procedure resultset into cursors.

example:

I want to get sp_validatelogin result set into curosors.

How??????????


thanks
keerthi

Hi Karl,

It worked for me.

Thank you
Keerthi


------------
keerthi at 9/5/01 2:42:23 PM

hi,

How can i get system stored procedure resultset into cursors.

example:

I want to get sp_validatelogin result set into curosors.

How??????????


thanks
keerthi