Fetching data from table every two hours

See more:

SQL-Server

Hi,
Iam trying to fetch the last updated record from my table.And it has to fetch every two hours.If no data is changed after two hours then we have to display the earlier data.I have written the stored procedure but it is not working.While trying to execute the query,Iam giving DateToday and DateNextDay with a duration of 2 hours which is available in the database.Can anyone help to find out the fault in the query.Or is there any other best way to do this?

ALTER PROCEDURE [dbo].[TwoHour_BalanceUpdate] 
	-- Add the parameters for the stored procedure here
	@ConsumerCode varchar(50),
	@DateToday datetime ,
    @DateNextDay datetime
    
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	select CURRENT_BALANCE from dbo.tbl_deposit where ID = (SELECT MAX(ID) FROM dbo.tbl_deposit) and ConsumerCode=@ConsumerCode and dbo.tbl_deposit.DEPOSIT_DATE between @DateToday and @DateNextDay
END