I dont know why my procedure doesnt work:

SET @fDate = CONVERT(DATE,CA ST(@year AS VARCHAR(25)) +'/'+ @month + '/01',111)
SET @lDate = CONVERT(DATE,CA ST(@year AS VARCHAR(25)) +'/' + @month + '/' + CAST(dbo.DaysIn Month(@fDate) AS VARCHAR(25)),11 1)

INSERT @TempTable --@TempTable is created inside procedure
SELECT Supplier, SUM(Total) AS Quantity, Monthly
FROM
(
SELECT...