solo en la consulta
algo asi:
Código SQL:
Ver originalCREATE TABLE #temp
(
fecha datetime,
id INT,
nombre VARCHAR(20),
total INT
)
INSERT INTO #temp VALUES ('2013-06-03 08:40:51.323', 110 ,'YOSMARY PEREZ', 1)
INSERT INTO #temp VALUES ('2013-06-03 09:03:42.523', 110, 'YOSMARY PEREZ', 1)
INSERT INTO #temp VALUES ('2013-06-03 09:14:49.650', 110, 'YOSMARY PEREZ', 1)
INSERT INTO #temp VALUES ('2013-06-03 09:37:44.563', 110, 'YOSMARY PEREZ', 1)
INSERT INTO #temp VALUES ('2013-06-03 09:44:00.110', 110, 'YOSMARY PEREZ', 1)
INSERT INTO #temp VALUES ('2013-06-03 09:47:24.633', 110, 'YOSMARY PEREZ', 1)
INSERT INTO #temp VALUES ('2013-06-03 09:48:30.183', 110, 'YOSMARY PEREZ', 1)
INSERT INTO #temp VALUES ('2013-06-03 10:06:45.797', 110, 'YOSMARY PEREZ', 1)
INSERT INTO #temp VALUES ('2013-06-03 10:18:22.010', 110, 'YOSMARY PEREZ', 1)
INSERT INTO #temp VALUES ('2013-06-03 10:22:37.877', 110, 'YOSMARY PEREZ', 1)
INSERT INTO #temp VALUES ('2013-06-03 10:27:24.150', 110, 'YOSMARY PEREZ', 1)
SELECT CONVERT(VARCHAR(20),fecha,101) AS fecha,id,nombre,SUM(total) FROM #temp
GROUP BY id,nombre,CONVERT(VARCHAR(20),fecha,101)
saludos!