--03 Client Synopsis Fact Sample.sql -- SE sample / sanity check (replaces FactClientSynopsis sample) SELECT TOP 100 td.[Corp Code] AS CorpCode, td.[Org Name] AS FormalName, td.[File #] AS TEFileNo, td.[Transaction Amount] AS Amount, td.[Funds on Deposit] AS FundsOnDeposit, td.[Transaction Date] AS TransactionDate, td.[Finance Transfer Type Desc] AS FinanceTransferType FROM se_reports.dbo.[udv_transaction_detail_34] td ORDER BY td.[Corp Code], td.[Transaction Date] DESC; SELECT td.[Corp Code] AS CorpCode, COUNT(*) AS [RowCount], SUM(ISNULL(td.[Transaction Amount], 0)) AS Amount, SUM(ISNULL(td.[Funds on Deposit], 0)) AS FundsOnDeposit FROM se_reports.dbo.[udv_transaction_detail_34] td GROUP BY td.[Corp Code] ORDER BY td.[Corp Code];