What I meant is that it probably isn't possible to do the insert, set
off the trigger, and do a select all within the single select.

But try it and see what happens.

It probably isn't possible to do it - so you might have to add a
select statement that inserts the data just before the Loop statement.