• 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