quote:

---

Originally posted by meberg66219

SELECT DATENAME(weekday, DateAdded) AS AddDate, DATEPART(week, DateAdded) AS WeekNumber, DATEPART(year, DateAdded)AS YearNumber,
COUNT(SyStudentID) AS NewStudents
FROM dbo.SyStudent
WHERE DateAdded >=dateadd(day,datediff(day,0,GetDate())- 7,0)
GROUP BY DateAdded
ORDER BY YearNumber, WeekNumber, AddDate

What I get as a return is:

AddDate=Friday
WeekNumber=50
YearNumber=2010
New Students=2

AddDate=Friday
WeekNumber=50
YearNumber=2010
NewStudents=1

and this goes on for however many entries there were for the day

What I need is this type of data:

AddDate=Friday
WeekNumber=50
YearNumber=2010
NewStudents=24

AddDate=Thursday
WeekNumber=50
YearNumber=2010
NewStudents=22

I need the query to count the total number of students per day and report that back instead of the same day 25 times with a count total of 1 or 2.

---

Would something like this work? I use it to count the number of help desk tickets created daily where I work. Perhaps you can modify it?

Select 
     count(DATENAME(weekday, DateAdded) AS AddDate), 
     DATEPART(week, DateAdded) AS WeekNumber, 
     DATEPART(year, DateAdded)AS YearNumber,
     SyStudentID AS NewStudents
     
from  dbo.SyStudent 
group by AddDate   

quote:

---

Originally posted by webfred

Hm...
All given solutions?

---

No, you're never too old to Yak'n'Roll if you're too young to die.

---