ALTER PROCEDURE [dbo].[address] 
        @id_doc

	@cod_kladr_work varchar( 50 ),
	@mail_index_work int,
        @region_kind_work nvarchar( 50 ),
        @region_work nvarchar( 50 ),
        @area_kind_work nvarchar( 15 ),
        @area_work nvarchar( 50 ),
        @city_kind_work nvarchar( 15 ),
        @city_work nvarchar( 50 ),
        @populated_kind_work nvarchar( 15 ),
        @populated_work nvarchar( 50 ),
        @street_kind_work nvarchar( 15 ),
        @street_work nvarchar( 50 ),
	@house_work nchar( 10 ),
	@corps_work nchar( 10 ),
	@quarter_work nchar( 10 ),

        @cod_kladr_1 varchar( 50 ),
	@mail_index_1 int,
        @region_kind_1 nvarchar( 50 ),
        @region_1 nvarchar( 50 ),
        @area_kind_1 nvarchar( 15 ),
        @area_1 nvarchar( 50 ),
        @city_kind_1 nvarchar( 15 ),
        @city_1 nvarchar( 50 ),
        @populated_kind_1 nvarchar( 15 ),
        @populated_1 nvarchar( 50 ),
        @street_kind_1 nvarchar( 15 ),
        @street_1 nvarchar( 50 ),
	@house_1 nchar( 10 ),
	@corps_1 nchar( 10 ),
	@quarter_1 nchar( 10 ),
       
        @cod_kladr_2 varchar( 50 ),
	@mail_index_2 int,
        @region_kind_2 nvarchar( 50 ),
        @region_2 nvarchar( 50 ),
        @area_kind_2 nvarchar( 15 ),
        @area_2 nvarchar( 50 ),
        @city_kind_2 nvarchar( 15 ),
        @city_2 nvarchar( 50 ),
        @populated_kind_2 nvarchar( 15 ),
        @populated_2 nvarchar( 50 ),
        @street_kind_2 nvarchar( 15 ),
        @street_2 nvarchar( 50 ),
	@house_2 nchar( 10 ),
	@corps_2 nchar( 10 ),
	@quarter_2 nchar( 10 )
--и тд 15 раз
AS
BEGIN
    UPDATE dbo.adres SET cod_kladr=@cod_kladr_1, mail_index=@mail_index_1, house=@house_1, corps=@corps_1, quarter=@quarter_1,  region_kind=@region_kind_1, region=@region_1, area_kind=@area_kind_1, area=@area_1, city_kind=@city_kind_1, city=@city_1, populated_kind=@populated_kind_1, populated=@populated_kind_1 ,street_kind=@street_kind_1, 
    street=@street_1
    WHERE id_doc=@id_doc AND type_address='1' 

 UPDATE dbo.adres SET cod_kladr=@cod_kladr_2, mail_index=@mail_index_2, house=@house_2, corps=@corps_2, quarter=@quarter_2,  region_kind=@region_kind_2, region=@region_2, area_kind=@area_kind_2, area=@area_2, city_kind=@city_kind_2, city=@city_2, populated_kind=@populated_kind_2, populated=@populated_kind_2 ,street_kind=@street_kind_2, 
    street=@street_2
    WHERE id_doc=@id_doc AND type_address='2' 
--и тд 15 раз
end

ALTER PROCEDURE [dbo].[address] 
        @id_doc

	@cod_kladr_work varchar( 50 ),
        @cod_kladr_1 varchar( 50 ),
        @cod_kladr_2 varchar( 50 )
--и тд 15 раз
AS
BEGIN
      declare @cod_kladr_1 varchar( 50 ),
      declare	@mail_index_1 int,
      declare  @region_kind_1 nvarchar( 50 ),
      declare  @region_1 nvarchar( 50 ),
      declare  @area_kind_1 nvarchar( 15 ),
      declare  @area_1 nvarchar( 50 ),
      declare  @city_kind_1 nvarchar( 15 ),
      declare  @city_1 nvarchar( 50 ),
      declare  @populated_kind_1 nvarchar( 15 ),
      declare  @populated_1 nvarchar( 50 ),
      declare  @street_kind_1 nvarchar( 15 ),
      declare  @street_1 nvarchar( 50 ),
      declare  @house_1 nchar( 10 ),
      declare @corps_1 nchar( 10 ),
      declare @quarter_1 nchar( 10 )
 --и тд 15 раз  
Select @cod_kladr_1=..--здесь нужен запрос к справочнику кладр, который заполнит все переменные, по коду кладр 

--а потом
 UPDATE dbo.adres SET cod_kladr=@cod_kladr_1, mail_index=@mail_index_1, house=@house_1, corps=@corps_1, quarter=@quarter_1,  region_kind=@region_kind_1, region=@region_1, area_kind=@area_kind_1, area=@area_1, city_kind=@city_kind_1, city=@city_1, populated_kind=@populated_kind_1, populated=@populated_kind_1 ,street_kind=@street_kind_1, 
    street=@street_1
    WHERE id_doc=@id_doc AND type_address='1' 
--и тд 15 раз
end