CREATE PROCEDURE DijagramUporedni  @KUPACID1 VARCHAR(15),@TIPUZORKA1 VARCHAR(1), @RudnikID1 VARCHAR(15), @AsortimanID1 VARCHAR(15), @DATUM1 AS DATETIME,  @DATUM2 AS DATETIME
AS


SELECT { fn MONTH(Datum) } AS Mjesec, { fn YEAR(Datum) } AS Godina, SUM(Tone) AS TonaUK, SUM(Tone * DTV)  AS ToplinaUK
FROM Flasice
WHERE  (KUPACID=@KUPACID1) AND (REDOVNI=@TIPUZORKA1) AND (RudnikID Like @RudnikID1) AND (AsortimanID Like @AsortimanID1) AND  (Datum BETWEEN @DATUM1 AND @DATUM2)
GROUP BY { fn MONTH(Datum) }, { fn YEAR(Datum) }
GO