ALTER TRIGGER [dbo].[FindOperatorHours]
ON [dbo].[tblTime]
INSTEAD OF INSERT
AS
BEGIN
INSERT tblTime (SetHours)
SELECT ISNULL(INSERTED.SetHours, tblUser.OperatorHours) AS SetHours
FROM INSERTED
JOIN tblUser ON INSERTED.Operator = tblUser.UserID
END