create table tb
(
id int, --employee id
starttime datetime --log time
)
go
INSERT INTO tb values (1,'2010-05-02 00:00:01')
INSERT INTO tb values (1,'2010-05-02 00:10:01')
INSERT INTO tb values (1,'2010-05-02 01:00:01')
INSERT INTO tb values (1,'2010-05-02 02:00:01')
INSERT INTO tb values (2,'2010-05-03 00:00:01')
INSERT INTO tb values (2,'2010-05-03 02:00:01')
INSERT INTO tb values (2,'2010-05-03 00:04:01')
INSERT INTO tb values (2,'2010-05-03 05:00:01')
SELECT id,min(starttime),max(starttime) from tb
group by datename(dd,starttime),id