SQL count statement
Posted on 2009-07-14
Table DIPApplication has 'x' records -- and
Agent_ID can be represented in many of these records, i.e. Data Entry ser stamp in record.
want to be able to produce a sql result where I can return:
[Agent_ID], [how many times DIPProcessed] from Sept 1st 2009
e.g. how many records that have DIPProcessed=1 associated with Agent_ID from Sept 1st 2009
list all unique Agent_ID's in table, along with the sum of their respective DIPProcessed
how do I write this type of query please?
Agent Ref.: Agent_ID (various int id's)
DIP Processed: DIPProcessed = 1 (means processed)
DateTime: DateTimeStamp (DateTime)
(using SQL Server Management Studio interface)
I can get the entire number of DIP's Processed as follows:
Just need to expand this query as described above.