/* Active Transferee — fact sample / counts (DatawarehouseNCM) */ SELECT 'FactActiveTransferee' AS FactName, COUNT(*) AS RowCnt, COUNT(DISTINCT TEFileNo) AS TECnt FROM dbo.FactActiveTransferee UNION ALL SELECT 'FactTEAccountDOTA', COUNT(*), COUNT(DISTINCT TEFileNo) FROM dbo.FactTEAccountDOTA; SELECT TOP 20 CashType, Source, InOut, COUNT(*) AS LineCnt, SUM(Amount) AS AmountSum FROM dbo.FactTEAccountDOTA GROUP BY CashType, Source, InOut ORDER BY CashType, Source, InOut; SELECT TOP 20 CorpCode, COUNT(DISTINCT TEFileNo) AS ActiveTECount, COUNT(*) AS ServiceRows FROM dbo.FactActiveTransferee GROUP BY CorpCode ORDER BY ActiveTECount DESC;