/* Fee Transfer Open — totals (DatawarehouseNCM) */ DECLARE @StartDate datetime = '2026-01-01'; DECLARE @EndDate datetime = '2026-01-31'; SELECT COUNT(*) AS InvoiceCount, SUM(OpenFeeAmount) AS TotalOpenFeeAmount FROM dbo.FactFeeTransferOpen WHERE InvoiceDate >= @StartDate AND InvoiceDate <= @EndDate;