I have a data export process using msdb..sp_send_dbmail. Most fields come out to the CSV export "clean" expect for a Notes field which is because of the various characters that seem to impact the @Query_Result_Separator. Is there a common recommendation as to how to solve this problem?
My query looks like this:
SET @QRY2 = 'SET NOCOUNT ON;SELECT ID, Notes FROM my Table'
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)