Thank you! This is what I have and it is trying to return more than one value. Any suggestions?
UPDATE #APPTRACKERLC
SET Remarks = (SELECT HIST.Comment FROM HISTORY WHERE HIST.Event IN ('AC','CTN','I1','I2','OA',
'OC','OD','OE','OO','RCT') AND HIST.History_ID = (SELECT TOP 1...