create table table1 (phone int,kod_name_d int ) --

create table table2 (nam_d nvarchar(30),kod int)

insert into table2 values('james',1)

insert into table2 values('stivens',2)

insert into table2 values('carlos',3)

create procedure inserttable1

@phone int,

@name varchar(30)

as

insert table1

select @phone,

kod

from table2

where nam_d = @name

go

EXEC inserttable1 @phone=11111,@name='james'

after inserted table1

phone kod_name_d

----- -----

11111 1

but i have 5 table for selection insert