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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)