Hi

I have the following query :
Code:
select count(*) as Produced from prodTable where DateCreated between @startdate and @enddate) Produced,
which returns a count of records created between 2 dates. These dates are @startdate = 1 week ago @enddate = today

What I now need is a result set which gives me a count by day and returns the days name

e.g
Code:
Tuesday, 24
Wednesday, 12,
Thursday, 34
Friday, 2 .....
Any ideas ?