Date And Count

Hi all, i am prity new to sql and am just learning (that hard way)


I have this code and i am trying to get out of it: a date with the number of calles that have been taken on that date between 2 dates.


SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

DECLARE @DisplayFrom as DATETIME
DECLARE @DisplayTo as DATETIME
DECLARE @FromDate as DATETIME
DECLARE @ToDate as DATETIME

SET @DisplayFrom = <%FromDate|Enter start date%>
SET @DisplayTo = <%ToDate|Enter end date%>
SET @FromDate = dbo.fUniversalTime(@DisplayFrom)
SET @ToDate = dbo.fUniversalTime(@DisplayTo)

SELECT SUM(ActiveDate), ActiveDate
FROM
(SELECT DISTINCT (ActiveDate) from [case])as T

where ActiveDate between @FromDate and @ToDate

group by ActiveDate



e.g. output

01/02/07 52
02/02/07 63
etc...

hope this makes sence

Neil