Retrieving data from stored procedure's cursor
SQL Server stored procedures can return record-sets from a query, a CURSOR would not be required (unlike in Oracle). The query below is all that's needed to get a recordset:

CREATE PROCEDURE dbo.SampleProcedure 
AS 
SELECT FIRST_NAME, LAST_NAME
FROM EMPLOYEE