You can use Temporary tables to achieve your goal.
ALTER proc [dbo].[sp_OeeEntryDisplay]
AS
Create Table #Temp
(
SN int Identity,
OeID varchar(50),
OeDate Datetime,
OeShift varchar(50),
OeLoct varchar(50),
OePOT varchar(50),
OeSPT varchar(50),
OeUPT varchar(50),
OeRT varchar(50),
)
Insert into #temp(OeID,OeDate,OeShift,OeLoct,OePOT,OeSPT,OeUPT ,OeRT )
select OeID,OeDate,OeShift,OeLoct,OePOT,OeSPT,OeUPT,OeRT,
from TPM_OeeEntry order by OeRT desc
select TOP 1 * from #temp;
Drop table #temp;
Hope this solves your problem.