INSERT INTO table1 (col1, col2, col3)
VALUES (1419002, 1003,
         (select TaskTypeCode
          from TaskTypeCodes
          where TaskTypeID in (898,788,878,874)) )

INSERT INTO table1 (col1, col2, col3)
SELECT 1419002, 1003, TaskTypeCode
FROM TaskTypeCodes
WHERE TaskTypeID in (898,788,878,874)).