Sunday, February 26, 2012

Group By Date in Stored Procedure

I am trying to to a transaction count (per day) running a stored procedure that does a group by date. The problem is that since the date has a time stamp (I assume) it sees each date as a different group even if it's the same day. Is there a way to format the date in the stored procedure so that it sees all of the transactions on the same day as one or is there another way to do this.

Select count(recordid),transactiondate
from sometable
group by transactiondate

Thanks

in advance

Select count(recordid),CONVERT(NCHAR(10),transactiondate,101)from sometable
group byCONVERT(NCHAR(10),transactiondate,101)

No comments:

Post a Comment