Count a timestamp field

[JDSmith14]

Hi Everybody

I have a Log table that logs all transactions for all users of a system.

I have the following fields:
User Name : String
Transaction Time : TimeStamp
Action : String

How do I get the total number of transactions PER TRANSACTON TYPE let say for a month? For exampe:

User1 : 15/08/2006: Edit Records : 30 events
User2 : 15/08/2006: Add Records : 20 events
User1 : 16/08/2006: Edit Records : 10 events
User2 : 16/08/2006: Add Records : 5 Events

Thanks

Johan Smith

 

[SQLSister]

Since timestamp is not in anyway shape or form a date datatype, I don't see where you have the data to do that. Please look it up in BOL to see what I mean.

Questions about posting. See faq183-874
Click here to help with Hurricane Relief