RETURNING RECORDSET FROM SQL SERVER STORED PROCEDURE?

HI EVERYONE,

I want to return a recordset from the Sql Server stored procedure.
The stored procedure is as follows:

// Little description about the stored Procedure is here
I have table named ABC from which i store the data in a CURSOR. And on the data of cursor i want to run another query on table named XYZ whose result i want to return in my ASP.
This procedure is working fine in SQL Server Query analyzer but didn't return any value in ASP.

CREATE PROCEDURE [dbo].[Week52Hi] AS
begin
      declare @Company varchar(30)
      declare @V_MAX(HI) INT
      
-- MY MAIN QUERY
DECLARE RS3 CURSOR FOR
(      SELECT Company, MAX(HIGHEST) MaxHigh
      FROM ABC
      WHERE
      DATE_TIME >= convert(char(12),dateadd(year,-1,getdate()),101) AND
      DATE_TIME < CONVERT(varchar,GetDate()-1,101)
      group by Company
      ORDER BY Company
)

Open RS3
      Fetch from RS3
      INTO @Companye,@V_MAX

while @@fetch_status = 0
 begin
      
      -- MY SUB-QUERY
      SELECT CompanyCode, Hi AS MaxHigh
      FROM ABC where date_time = CONVERT(char,getdate(),101)
      AND CompanyCode=@Company
      AND DATE_TIME = (SELECT Max(Date_Time) FROM ABC WHERE CompanyCode=@COMPANY)
      AND HI > @v_max ORDER BY Company


       Fetch from RS3
       INTO @Company,@v_max
          
 end

close RS3
deallocate RS3

end
GO


Thanx in Advance.
Waiting for your kind replys.

Regards,
Rafay