--03 Revenue By State Fact Sample.sql -- SE sample / sanity check (replaces FactRevenueByState sample) SELECT TOP 100 td.[Corp Code] AS CorpCode, td.[File #] AS GroupId, td.[Last Name] AS TELastName, td.[Invoice Date] AS DocDate, td.[Transaction Amount] AS Amount, pf.[Dest Work City] AS City, pf.[Dest Work State] AS State, td.[Expense Item] AS ActDescr, td.[Source Type] AS Source FROM se_reports.dbo.[udv_transaction_detail_34] td JOIN se_reports.dbo.[udv_profile_information_view_34] pf ON td.[File #] = pf.[File #] ORDER BY td.[Invoice Date] DESC; SELECT pf.[Dest Work State] AS State, COUNT(*) AS [RowCount], SUM(ISNULL(td.[Transaction Amount], 0)) AS Amount FROM se_reports.dbo.[udv_transaction_detail_34] td JOIN se_reports.dbo.[udv_profile_information_view_34] pf ON td.[File #] = pf.[File #] GROUP BY pf.[Dest Work State] ORDER BY Amount DESC;