Hello, is this a good/valid way to bail out of a Before Insert trigger before continuing other work? Will it allow the trigger to continue processing?
DECLARE @TripType AS Varchar(150)
-- Make sure this is a student trip, else bail out and allow the insert to proceed.
SELECT @TripType = TripType FROM tblTrips WHERE TripNo = (SELECT TripNo FROM inserted);
IF @TripType <> 'Student (ST)' RETURN 0