SqlReports
Changes
RevenueComparationByCategories.sql 9(+6 -3)
Details
RevenueComparationByCategories.sql 9(+6 -3)
diff --git a/RevenueComparationByCategories.sql b/RevenueComparationByCategories.sql
index 102cd1f..77031c3 100644
--- a/RevenueComparationByCategories.sql
+++ b/RevenueComparationByCategories.sql
@@ -42,15 +42,18 @@ begin
declare @LastPeriodDateTo DateTime
declare @PeriodTable table (
- ID int,
+ ID Int,
ActualPeriodDateFrom DateTime,
ActualPeriodDateTo DateTime,
LastPeriodDateFrom DateTime,
LastPeriodDateTo DateTime,
+ Period2DateFrom DateTime,
+ Period2DateTo DateTime,
+ Period1DateFrom DateTime,
+ Period1DateTo DateTime,
PeiodDescription nvarchar(256)
)
-
-
+
insert into @PeriodTable
exec dbo.GetPeriodList_For_RevenueComparation @PeriodTypeID