Hi ,

I have a table t1(col1 int,col2 int)
and an instead-of-insert trigger for the table. The problem is
that no row gets inserted in t1 with the following scheme of things.
If I remove the insert in the stored proc and place it in the trigger
after the call to the stored proc, the row gets inserted

/****/
create trigger test on t1 instead of insert as
begin
select * into #inserted from inserted
exec sp_updatetemptable

end

create proc sp_updatetemptable as
begin
update #inserted set col2=2
insert into t1 select * from #inserted
end

/****/