That are you doing inside of the usp_translatetext? You are calling it 1 line at a time, thus requiring a cursor like structure. Could usp_translatetext perhaps be changed...

Just to confirm Tim's comment. I was able to modify sp_send_cdosysmail by adding an attachment parameter and the line

EXEC @hr = sp_OAMethod @iMsg, 'AddAttachment',@rv out, @ATTACHMENT

--@rv captures the...

Probably overkill, but one straight forward way to get your result set is simply to create another copy of your table that doesn't allow null, copy all the data and...