procedure create Test
(
@searh int
)

as
begin
      if @searh =  1 
      begin 
         ЧТО ТО ДЕЛАЮ....
      end
      else
      if @searh =  2 
      begin 
         ЧТО ТО ДЕЛАЮ....
      end
end

ALTER PROCEDURE GET_REPORT_PROCENT
(
	@VAL INT =  810 
)
AS 
BEGIN
	IF @VAL=  810 
	BEGIN
	SELECT RUR31 AS S31 , RUR61 AS S61 , RUR91 AS S91, RUR121 AS S121 , RUR181 AS S181 , RUR275 AS S275, RUR370 AS S370, SUMMRUR, FILIALS.NAME, BANKLITLENAME, GROUP_RUR, DBO.GetDescription([BANKLITLENAME]) AS MDESCRIPTION,
	CASE BANK_KONCURENT.ID WHEN  25  THEN  1  ELSE  0  END AS SKB
	FROM PROCENT_KONCURENT_OBL INNER JOIN FILIALS ON PROCENT_KONCURENT_OBL.FILIAL = FILIALS.ID
	                           INNER JOIN BANK_KONCURENT ON PROCENT_KONCURENT_OBL.NAME = BANK_KONCURENT.ID
	ORDER BY GROUP_RUR
	END
	else
	IF @VAL=  840 
	BEGIN
	SELECT USD31 AS S31, USD61 AS S61, USD91 AS S91, USD121 AS S121, USD181 AS S181, USD275 AS S275, USD370 AS S370, SUMMUSD, FILIALS.NAME, BANKLITLENAME, GROUP_VAL, DBO.GetDescription([BANKLITLENAME]) AS MDESCRIPTION,
	CASE BANK_KONCURENT.ID WHEN  25  THEN  1  ELSE  0  END AS SKB
	FROM PROCENT_KONCURENT_OBL INNER JOIN FILIALS ON PROCENT_KONCURENT_OBL.FILIAL = FILIALS.ID
	                           INNER JOIN BANK_KONCURENT ON PROCENT_KONCURENT_OBL.NAME = BANK_KONCURENT.ID
	ORDER BY GROUP_VAL
	END
        else
	IF @VAL=  978 
	BEGIN
	SELECT EUR31 AS S31, EUR61 AS S61, EUR91 AS S91, EUR121 AS S121, EUR181 AS S181, EUR275 AS S275, EUR370 AS S370, SUMMEUR, FILIALS.NAME, BANKLITLENAME, GROUP_VAL, DBO.GetDescription([BANKLITLENAME]) AS MDESCRIPTION,
	CASE BANK_KONCURENT.ID WHEN  25  THEN  1  ELSE  0  END AS SKB
	FROM PROCENT_KONCURENT_OBL INNER JOIN FILIALS ON PROCENT_KONCURENT_OBL.FILIAL = FILIALS.ID
	                           INNER JOIN BANK_KONCURENT ON PROCENT_KONCURENT_OBL.NAME = BANK_KONCURENT.ID
	ORDER BY GROUP_VAL
	END
END