WITH Grouped AS (
    SELECT
         Account
    ,    Date
    ,    SUM(Amount) OVER (PARTITION BY Account, Date) AS Amount
    ,    RecID
    FROM #MyTrans
    )
SELECT
     Account
,    Date
,    Amount
,    RecID
FROM Grouped
WHERE Amount > 0

John