Using ROW_NUMBER function in SQL Server 2000

The code here is not supported in SQL Server 2000

Pplease help

SET @admno = (SELECT admno FROM (SELECT ROW_NUMBER() OVER( ORDER BY (SELECT 0)) RowId,* FROM temp) t WHERE t.RowId = @Counter)
SET @types = (SELECT stdtype FROM (SELECT ROW_NUMBER() OVER( ORDER BY (SELECT 0)) RowId,* FROM temp) t WHERE t.RowId = @Counter)
SET @Rdate = (select Dreturn FROM setdates2 where [class] like '%'+@c+'%' and studenttype=@types)

PROCEDURE [dbo].[UPdateDatereturn] @c nvarchar(50) AS 
BEGIN
    DECLARE @admno nvarchar(50)
    DECLARE @class nvarchar(50)
    DECLARE @types nvarchar(50)
    DECLARE @Rdate datetime
    
    DECLARE @Sum INT = 0
    DECLARE @Counter INT, @TotalCount INT
    
    SET @Counter = 1  
    SET @TotalCount = (SELECT COUNT(*) FROM temp)   
    WHILE (@Counter <= @TotalCount)
    BEGIN
        SET @admno = (SELECT admno FROM (SELECT ROW_NUMBER() OVER( ORDER BY (SELECT 0)) RowId,* FROM temp) t WHERE t.RowId = @Counter)
        SET @types = (SELECT stdtype FROM (SELECT ROW_NUMBER() OVER( ORDER BY (SELECT 0)) RowId,* FROM temp) t WHERE t.RowId = @Counter)
       SET @Rdate = (select Dreturn FROM setdates2 where [class] like '%'+@c+'%' and studenttype=@types)
       
        IF @types='DAY' 
        BEGIN           
            UPDATE P3P7 SET Returnsd =Convert (datetime,@Rdate,103)  WHERE admno = @admno
        END
       
	   ELSE IF @types='BOARDER'
        BEGIN
            UPDATE P3P7 SET Returnsd = Convert (datetime,@Rdate,103) WHERE admno = @admno
        END
     
        SET @Counter = @Counter + 1
        CONTINUE;
    END
END