Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Flaterik
Starting Member
26 Posts |
 Posted - 2011-05-31 : 05:18:45
|
Hi people i have this type of query quote:
SUM(CASE WHEN MONTH(DataDoc)= 1 THEN Qta ELSE NULL END) AS Gennaio, SUM(CASE WHEN MONTH(DataDoc) = 2 THEN qta ELSE NULL END) AS Febbraio, SUM(CASE WHEN MONTH(DataDoc) = 3 THEN Qta ELSE NULL END) AS Marzo, SUM(CASE WHEN MONTH(DataDoc) = 4 THEN Qta ELSE NULL END) AS Aprile, SUM(CASE WHEN MONTH(DataDoc) = 5 THEN Qta ELSE NULL END) AS Maggio, SUM(CASE WHEN MONTH(DataDoc) = 6 THEN Qta ELSE NULL END) AS Giugno, SUM(CASE WHEN MONTH(DataDoc) = 7 THEN Qta ELSE NULL END) AS Luglio, SUM(CASE WHEN MONTH(DataDoc) = 8 THEN Qta ELSE NULL END) AS Agosto, SUM(CASE WHEN MONTH(DataDoc) = 9 THEN Qta ELSE NULL END) AS Settembre, SUM(CASE WHEN MONTH(DataDoc) = 10 THEN Qta ELSE NULL END) AS Ottobre, SUM(CASE WHEN MONTH(DataDoc) = 11 THEN Qta ELSE NULL END) AS Novembre, SUM(CASE WHEN MONTH(DataDoc) = 12 THEN Qta ELSE NULL END) AS Dicembre,
Now i must use this condition but i the month that i must use are the last 12 month.For Example now the month 1 for me must be June (today is may ) , month 2 Julythe world is strange but people are crazy |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-05-31 : 05:52:52
|
[code]SUM(CASE WHEN MONTH(DataDoc) = month(dateadd(month, -11, getdate())) THEN Qta END) AS Month_01,SUM(CASE WHEN MONTH(DataDoc) = month(dateadd(month, -10, getdate())) THEN Qta END) AS Month_02,...[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
|
|
Last 12 month in sql