SqlReports

+

8/27/2020 11:04:10 AM

Changes

GetTotalEncashmentsStats.sql 29(+0 -29)

Details

diff --git a/GetEncashmentsStats.sql b/GetEncashmentsStats.sql
index 750d3cb..5a1417e 100644
--- a/GetEncashmentsStats.sql
+++ b/GetEncashmentsStats.sql
@@ -36,10 +36,12 @@ begin
 --set @DateFrom = convert(DateTime, '15.04.2019', 104)	
 --set @DateTo = convert(DateTime, '21.04.2019', 104)	
 	
-	declare @DateTo_Date DateTime
-	set @DateTo_Date = cast(@DateTo as Date)
+	declare @DateFromInt DateTime
+	declare @DateToInt DateTime
 
-	set @DateTo = dateadd(ms, -2, dateadd(day, 1, @DateTo_Date))
+	set @DateFromInt = cast(@DateFrom as Date)
+	set @DateToInt = cast(@DateTo as Date)
+	set @DateToInt = dateadd(ms, -2, dateadd(day, 1, @DateToInt))
 	
 	declare @EncashmentsList table (ID int identity(1,1), ShopID int, TerminalID nvarchar(256),  EncashmentDate DateTime, FromSessionID int, ToSessionID int) 
 	
@@ -61,7 +63,7 @@ begin
 				and s.CompanyId = @CompanyID
 		
 		where
-				e.Timestamp between @DateFrom and @DateTo
+				e.Timestamp between @DateFromInt and @DateToInt
 			and (isnull(@ShopID, 0) = 0 or t.ShopId = @ShopID)
 		
 		declare @t1 table (ID int index IX1, EncashmentCount int, EncashmentSumm decimal(15, 2))