--02 Client Synopsis Daily Activity.sql -- SE rewrite of BO Client Synopsis daily activity (FactClientSynopsis SumType='D') -- View: udv_transaction_detail_34 SELECT td.[Corp Code] AS CorpCode, MAX(td.[Org Name]) AS FormalName, SUM(CAST(0.00 AS DECIMAL(18, 2))) AS CashInToday, -- InOut — unable to find SUM(CAST(0.00 AS DECIMAL(18, 2))) AS CashOutToday, -- InOut — unable to find SUM(ISNULL(td.[Transaction Amount], 0)) AS NetCashToday, -- approximate MAX(td.[Transaction Date]) AS AsOfDate FROM se_reports.dbo.[udv_transaction_detail_34] td WHERE CAST(td.[Transaction Date] AS date) = CAST(GETDATE() AS date) -- BO daily = AsOfDate populate day GROUP BY td.[Corp Code] ORDER BY td.[Corp Code];