crazy_new (9/2/2014)
In this specific situation your will never be able to add more than one, because this trigger is just for two people on a single client, one is a supervisor and one is the so called owner, and you can only have one of each per client. But by writing it to deal with batch inserts, would you write a cursor in to execute this for all the new ID's inserted?
Don't use a cursor (ever!) Use sets based logic
Gerald Britton, Pluralsight courses