CREATE VIEW [dbo].[SalesAggregated] with schemabinding AS
        SELECT
            BusinessDate,
            ItemId
            ,COUNT_BIG(*) AS NumberOfRows
            ,SUM(Gross) AS Gross
        FROM [dbo].[myTable]
        GROUP BY BusinessDate, ItemId