1> select * from t;
2> go
date |Iscomplete
-----------------------|-----------
2011-05-15 01:00:00.000| 1
2011-05-15 02:00:00.000| 0
2011-05-15 03:00:00.000| 1
2011-05-16 01:00:00.000| 1
2011-05-16 02:00:00.000| 0
(5 rows affected)
1>
1> select CONVERT(varchar,date,102) as d,avg(Iscomplete+0.0) as c
2> from t
3> group by CONVERT(varchar,date,102)
4> go
d |c
------------------------------|----------------------------------------
2011.05.15 | .666666
2011.05.16 | .500000
(2 rows affected)
1>
