0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

;WITH Orders AS (
    	SELECT * FROM (VALUES
    		(CAST('2012-01-01 06:10:01' AS DATETIME), 2)
    		, ('2012-01-01 08:10:01', 2)
    		, ('2012-01-01 10:10:01', 4)
    		, ('2012-01-02 08:00:07', 4)
    		, ('2012-01-02 10:00:07', 4)
    	) AS Orders (DateReceived, Total)		
    )
    SELECT	CONVERT(varchar, DATEADD(hour, -10, [DateReceived]), 111) AS [dt_DateReceived]
    		, SUM([Total]) AS perday
    FROM	[Orders] 
    GROUP BY 
    		CONVERT(varchar, DATEADD(hour, -10, [DateReceived]), 111)
    ORDER BY 
    		1

fork query

edited sep 6 12

created jan 25 12 anonymous