DROP TABLE #TTMP
CREATE TABLE #TTMP(ADATE DATETIME,
FILIAL INT, MON INT, Y INT, OST FLOAT)

INSERT INTO #TTMP
SELECT BALANCE.ADATE, BALANCE.FILIAL, MONTH(BALANCE.ADATE) AS MON, YEAR(BALANCE.ADATE) AS Y,
	SUM(BALANCE.IN_RUB+BALANCE.IN_VAL) AS OST
FROM BALANCE, SH
WHERE BALANCE.SH = SH.SH AND
	BALANCE.VAL =  810 
GROUP BY BALANCE.ADATE, BALANCE.FILIAL


SELECT  #TTMP.Y,#TTMP.MON, #TTMP.FILIAL,SUM(#TTMP.OST)AS OST
FROM #TTMP
GROUP BY #TTMP.Y, #TTMP.FILIAL, #TTMP.MON
ORDER BY #TTMP.Y, #TTMP.FILIAL, #TTMP.MON

ALTER PROCEDURE test1
 /*	(
		@parameter1 datatype = default value,
	)
*/ 
AS

DROP TABLE #TTMP
CREATE TABLE #TTMP(ADATE DATETIME,
FILIAL INT, MON INT, Y INT, OST FLOAT)

INSERT INTO #TTMP
SELECT BALANCE.ADATE, BALANCE.FILIAL, MONTH(BALANCE.ADATE) AS MON, YEAR(BALANCE.ADATE) AS Y,
	SUM(BALANCE.IN_RUB+BALANCE.IN_VAL) AS OST
FROM BALANCE, SH
WHERE BALANCE.SH = SH.SH AND
	BALANCE.VAL =  810 
GROUP BY BALANCE.ADATE, BALANCE.FILIAL


SELECT  #TTMP.Y, #TTMP.MON, #TTMP.FILIAL, AVG(#TTMP.OST) AS OST
FROM #TTMP
GROUP BY #TTMP.Y, #TTMP.FILIAL, #TTMP.MON
ORDER BY #TTMP.Y, #TTMP.FILIAL, #TTMP.MON

ALTER PROCEDURE TEST
(
	@IY INT =  2002 ,
	@IMON INT =  1 
)

AS
BEGIN
	SET NOCOUNT ON
 /*
	DECLARE @IY INT
	DECLARE @IMON INT

	SET @IY = 2002
	SET @IMON = 1
*/ 
	DECLARE @TTMP TABLE (ADATE DATETIME, FILIAL INT, MON INT, Y INT, OST FLOAT, ID INT IDENTITY( 1 , 1 ) UNIQUE)

	INSERT INTO @TTMP (ADATE, FILIAL, MON,Y,OST)
	SELECT BALANCE.ADATE, BALANCE.FILIAL, MONTH(BALANCE.ADATE) AS MON, YEAR(BALANCE.ADATE) AS Y,
SUM(BALANCE.IN_RUB+BALANCE.IN_VAL) AS OST
	FROM BALANCE, SH
	WHERE BALANCE.SH = SH.SH AND
		BALANCE.VAL =  810  AND
		@IY = YEAR(BALANCE.ADATE) AND
		@IMON = MONTH(BALANCE.ADATE)
	GROUP BY BALANCE.ADATE, BALANCE.FILIAL


	SELECT FILIAL, AVG(OST) AS OST
	FROM @TTMP
	GROUP BY Y, MON, FILIAL
END