|
bandi
Flowing Fount of Yak Knowledge
India
1418 Posts |
 Posted - 03/08/2013 : 04:25:06
|
DECLARE @Tab TABLE (value INT, id INT, dataVal dateTime)
INSERT INTO @Tab
SELECT 32, 111, '05/15/10 0:00' UNION ALL
SELECT 27, 111, '05/15/10 0:15' UNION ALL
SELECT 4, 111, '05/15/10 0:30' UNION ALL
SELECT 0, 111, '05/15/10 0:45' UNION ALL
SELECT 1320, 112, '05/15/10 0:45' UNION ALL
SELECT 1369, 112, '05/15/10 0:30' UNION ALL
SELECT 1453, 112, '05/15/10 0:15' UNION ALL
SELECT 1539, 112, '05/15/10 0:00' UNION ALL
SELECT 971, 113, '05/15/10 0:00' UNION ALL
SELECT 930, 113, '05/15/10 0:15' UNION ALL
SELECT 871, 113, '05/15/10 0:30' UNION ALL
SELECT 823, 113, '05/15/10 0:45'
--and i need query to sum 'value' for each date, result should look like this:
/*sum date
2542 05/15/10 0:00
2410 05/15/10 0:15
2244 05/15/10 0:30
2143 05/15/10 0:45*/
SELECT SUM(value) sumVal, dataVal
FROM @tab
GROUP BY dataVal
--
Chandu |
 |
|
Sum of value for each date
