THANK YOU VERY MUCH VETERAN
but i created this
create procedure inserttable1
@phone int,
@n nvarchar(30),@f nvarchar(30),@c nvarchar (30),@t nvarchar(30)
as
insert table1
(phone,kod_name,kod_fname,kod_country,kod_auto)
select @phone,(select kod from table2 where name_=@n),(select kod from table3 where f_name=@f),
(select kod from table4 where country=@c),(select kod from table5 where m_auto=@t)
insert test
(phone,kod_name,kod_fname,kod_country,kod_auto)
select
phone,kod_name,kod_fname,kod_country,kod_auto from table1 where phone=@phone and phone is not null and phone<>0
exec inserttable1 '','stivens','tayson','argentina','mersedec'
thank you very much