I am trying to create a stored procedure on SQL server 2000 that returns a recordset for a cursor (in another stored procedure).
I know how to do it as an output parameter but I want to do it like I would return a recordset for VB.
i.e.
'CREATE PROCEDURE GetRS() AS
SELECT * FROM t_Table'
And not:
'CREATE PROCEDIRE GetRS(@rsTable CURSOR VARYING OUTPUT) AS
SET @rsTable = CURSOR FOR
SELECT * FROM t_Table
OPEN @rsTable'
Does anyone know if this is possible?
