1 2 3 4 5 6
| SET DATEFORMAT DMY SELECT SUBSTRING(CONVERT(char(10), EDIT.EDIT_IN_E, 103), 4, 7) AS MOIS, " _
& " EDITRICE_E AS USERNAME, SUM(EDIT.NBPAGE_E * ((-0.2) + 1.2)) As TOTAL " _
& " FROM EDIT LEFT JOIN EQUIV ON EDIT.IDREC = EQUIV.IDREC " _
& " WHERE (EDIT.EDIT_IN_E >= '" & TempDate1 & "') AND (EDIT.EDIT_IN_E <= GETDATE()) " _
& " GROUP BY SUBSTRING(CONVERT(char(10), EDIT.EDIT_IN_E, 103),4, 7), EDITRICE_E" _
& " ORDER BY SUBSTRING(CONVERT(char(10), EDIT.EDIT_IN_E, 103),4, 7), EDITRICE_E } AS dbo_Req_Production COMPUTE dbo_Req_Production BY MOIS" |
Partager