Note: This question was not tagged SQL Server 2005 when I answered it. I am leaving the answer, because it is appropriate for SQL Server 2008+.
If you just care about the date and not the time, you need a combination of casting and datediff():
SELECT COUNT(RSO_ParentID), AssignedDateTime FROM Task WHERE OwnerTeam = '2nd Line Support' AND AssignedDateTime >= dateadiff(day, -7, cast(getdate() as date)) GROUP BY AssignedDateTime;
Note that you can also express this using functions on AssignedDateTime. That is generally a bad idea because it often prevents the use of indexes for the query.
I also am guessing that you want the results by day:
SELECT COUNT(RSO_ParentID), cast(AssignedDateTime as date) FROM Task WHERE OwnerTeam = '2nd Line Support' AND AssignedDateTime >= dateadiff(day, -7, cast(getdate() as date)) GROUP BY cast(AssignedDateTime as date);
or a total, in which you don't want a group by clause:
SELECT COUNT(RSO_ParentID) FROM Task WHERE OwnerTeam = '2nd Line Support' AND AssignedDateTime >= dateadiff(day, -7, cast(getdate() as date));
GROUP BY AssignedDateTimeDo you want records to ignore the time for purposes of the grouping?