1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
;WITH JeuEssai AS (
SELECT 1 as id, CAST('2012-11-25T23:45:32' as DATETIME) as dte, 1 as qte
UNION ALL SELECT 1 as id, CAST('2012-11-27T23:44:32' as DATETIME) as dte, 10 as qte
UNION ALL SELECT 1 as id, CAST('2012-12-10T23:45:32' as DATETIME) as dte, 20 as qte
UNION ALL SELECT 1 as id, CAST('2012-12-15T20:45:32' as DATETIME) as dte, 75 as qte
UNION ALL SELECT 1 as id, CAST('2012-12-27T20:10:32' as DATETIME) as dte, 17 as qte
UNION ALL SELECT 1 as id, CAST('2012-12-30T23:35:00' as DATETIME) as dte, 2 as qte
UNION ALL SELECT 1 as id, CAST('2013-01-25T23:45:32' as DATETIME) as dte, 112 as qte
UNION ALL SELECT 1 as id, CAST('2013-01-25T10:45:32' as DATETIME) as dte, 34 as qte
UNION ALL SELECT 1 as id, CAST('2013-01-27T12:45:32' as DATETIME) as dte, 61 as qte
UNION ALL SELECT 1 as id, CAST('2013-01-28T23:23:32' as DATETIME) as dte, 89 as qte
UNION ALL SELECT 1 as id, CAST('2013-02-10T23:45:32' as DATETIME) as dte, 9 as qte
)
SELECT
DATEADD(
MONTH,
DATEDIFF(
MONTH,
0,
dte
),
0
),
SUM(qte)
FROM JeuEssai
GROUP BY
DATEADD(
MONTH,
DATEDIFF(
MONTH,
0,
dte
),
0
) |
Partager