select COUNT (*) as [TOTAL Transaction for the day],
dateadd(day, datediff(day, 0, txndate), 0) as [Date]
where user_name ='user'
and txnDate >= '2012-05-01'
and txnDate < '2012-06-01'
groub by dateadd(day, datediff(day, 0, txndate), 0)
Monthly ? shouldn't it be up to 31st of May ?
Time is always against us