Statistik - count måned

SELECT Year(sdato) AS WYear, Month(sdato) AS WMonth, Count(*) AS Hits FROM Table GROUP BY WYear, WMonth

Er ikke helt sikker på den... men tror det er noget ala det..

ups, det var et svar!

Gir
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'WYear'.

Fandt selv en løsning :-)

<%
conn.Open strDSN
dim MonthArray(12)

MonthArray(1) = "Januar"
MonthArray(2) = "Februar"
MonthArray(3) = "Marts"
MonthArray(4) = "April"
MonthArray(5) = "Maj"
MonthArray(6) = "Juni"
MonthArray(7) = "Juli"
MonthArray(8) = "August"
MonthArray(9) = "September"
MonthArray(10) = "Oktober"
MonthArray(11) = "November"
MonthArray(12) = "December"
maaned = 1
Do until maaned = 13
sql = "SELECT count(*) as antal FROM taeller where Month(sdato) = " & maaned
Set rs = Conn.Execute(SQL)
if rs("antal") > 0 then
Response.Write MonthArray(maaned) & " " & rs("antal") & "<br>"
end if
maaned = maaned+1
Loop
set rs = nothing
conn.close
%>