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