Is there a logical mistake in the below trigger. What I am asking for is an advice ... is it possible for this trigger to execute concurrently and pass @TimeCardID of another user to a procedure dbo.SynchINSCost. If it is possible, how can it be prevented?
CREATE trigger dbo.trInsertTimeCard
set nocount on
declare @TimeCardID int
select @TimeCardID = tc.int_TimeCardID from tblTimeCard tc
inner join inserted i on
i.int_TimeCardID = tc.int_TimeCardID
exec dbo.SynchINSCost @TimeCardID