SqlReports
Details
GetEncashmentsStats.sql 10(+6 -4)
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))