dbo.TIMED_DISCOUNTS_REPORT_WEEK.View.sql

USE [u_wdrozdz]
GO
/****** Object:  View [dbo].[TIMED_DISCOUNTS_REPORT_WEEK]    Script Date: 18.03.2022 12:35:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[TIMED_DISCOUNTS_REPORT_WEEK]
as
Select YEAR(ActiveFrom) as Year, DATEPART(WEEK, ActiveFrom) as Week, EntryID as 'Discount ID', [Discount Percentage],  Count(*) as 'Granted times' from TIMED_DISCOUNTS_VIEW
where EntryID is not NULL
group by EntryID, YEAR(ActiveFrom), DATEPART(WEEK, ActiveFrom), [Discount Percentage]
GO