How to insert values into multiple tables using a View?

create trigger sriviewtrigger9
on sriview
instead of insert
as
begin
set nocount on
declare @countryid int
declare @stateid int
declare @statecid int
declare @cityid int
declare @citystateid int

if(not exists (select ctry.countryname from country ctry,inserted i where ctry.countryname=i.country))
insert into country(countryname) select country from inserted


if(not exists (select s.statename from state s,inserted i where s.statename=i.state))
begin

insert into state (statecid,statename) values(select ctry.countryid from country ctry,inserted i where ctry.countryname=i.country,select state from inserted)
end

if(not exists(select c.cityname from city c,inserted i where c.cityname=i.city))
begin
set @stateid=select s.stateid from state s,inserted i where s.statname=i.state
insert into city (cityname,citystateid) values (select city from inserted,@stateid)
end

end