/* FactEstReferralEstimate — fact sample / coverage checks Run on DatawarehouseNCM after EXEC dbo.PrcPopulateEstReferralEstimate; */ SELECT TOP (100) e.FactEstReferralEstimateID, e.Type, e.ServiceCode, e.TEFileNo, e.CorpCode, e.EstCOE, e.ActualCOE, e.ResaleAmount, e.ReferralPercentage, e.AgentCommission, e.CalculatedReferral, e.EstimatedReferral, e.MonthToCOE, e.DimMainID, e.DimConsultantID, e.SourceKey FROM dbo.FactEstReferralEstimate e ORDER BY e.Type, e.EstCOE DESC, e.TEFileNo; SELECT Type, COUNT(*) AS RowCount, COUNT(DISTINCT TEFileNo) AS FileCount, SUM(CASE WHEN DimMainID IS NULL THEN 1 ELSE 0 END) AS NullDimMain, SUM(CASE WHEN DimConsultantID IS NULL THEN 1 ELSE 0 END) AS NullDimConsultant, MIN(EstCOE) AS MinEstCOE, MAX(EstCOE) AS MaxEstCOE FROM dbo.FactEstReferralEstimate GROUP BY Type ORDER BY Type;