I am not sure that I follow your Select statement below:

SET @Note_10 = @Note_10 + '----'

SELECT @Note_10 = @Note_10 + WONo + ', ' FROM PELDMS.dbo.ImportLog1 WHERE Profile = @Profile_3

What...