InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 06:44:48 GMT20http://www.sqlservercentral.com/Forums/Topic1394672-391-1.aspxThanks Chris, I must admit I tried everything except that yesterday.. that worked a treatTue, 11 Dec 2012 01:19:00 GMTmick burdenhttp://www.sqlservercentral.com/Forums/Topic1394672-391-1.aspxseems simple enough, your dates should be in the WHERE clause, not GROUP BY clause, like this:[code="sql"]SELECT sName, SUM(sinterventions) AS sinterventions, SUM(sareas) AS sareas FROM mytable WHERE DateValue BETWEEN '2012-12-20' AND '2012-12-23' GROUP BY sName[/code]Mon, 10 Dec 2012 10:22:04 GMTChris Harshmanhttp://www.sqlservercentral.com/Forums/Topic1394672-391-1.aspxI want to be able to add together values from fields that come between 2 dates, I've created a table script below[code] IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL DROP TABLE #mytableCREATE TABLE mytable ( DateValue DATETIME, sName varchar(50), sinterventions INT, sareas INT ) -- Inserting Data into TableINSERT INTO mytable(DateValue,sName,sinterventions,sareas) VALUES ('23/Dec/2012','Mike',99,23)INSERT INTO mytable(DateValue,sName,sinterventions,sareas) VALUES ('22/Dec/2012','Joe',43,3)INSERT INTO mytable(DateValue,sName,sinterventions,sareas) VALUES ('20/Dec/2012','Tony',5,66)INSERT INTO mytable(DateValue,sName,sinterventions,sareas) VALUES ('21/Dec/2012','Mike',11,44)INSERT INTO mytable(DateValue,sName,sinterventions,sareas) VALUES ('20/Dec/2012','sally',1,440)INSERT INTO mytable(DateValue,sName,sinterventions,sareas) VALUES ('21/Dec/2012','sally',11,20)INSERT INTO mytable(DateValue,sName,sinterventions,sareas) VALUES ('20/Nov/2012','Joy',121,70)[/code]What I'd like to return is if I query the data between 20/dec/2012 and 23/Dec/2012, Mike 110 67Joe 43 3Tony 5 66Sally 12 460I've tried GroupBy but that just splits it over dates, so I'll get 2 Sally's etc. How could this be achieved?Mon, 10 Dec 2012 09:12:58 GMTmick burden