SQL - Sum of Cash based on Customer ID
Posted on 2013-10-23
To my dearest experts,
I've searched the KB, but can't locate a basic version of what I'm looking for.
I have a Transaction table (ActivityHist) that show's bank activity. What I need is (hopefully) a rather simple solution. I want to see a list of Transactions (TranNo) on a specific Date (BookDate) broken down by Customer (CustID) with a sum of activity (BaseAmt) of 10000.01 or higher.
All data fields are in the same table, no joins and such required.
Any and all help would be greatly appreciated.