mister.magoo (3/31/2015)
If this is copying and pasting one cell from SSMS to one cell in Excel, then make sure you are in edit mode in Excel before pasting, either by pressing F2 after clicking on the cell or by clicking twice, slowly - don't double-click.You will know you are in edit mode by the flashing cursor inside the cell in Excel.
Thank you mister.magoo (nice nickname btw) but still same result.
Tried pasting it into Word, and same thing, so I'm getting the impression it's a SQL 2008 issue on the "copy" side of things...
If there is VB code executing the select and pasting of the resulting recordset, then the Chr13 are "respected"... just when Ctrl-C & Ctrl-V are used, it doesn't work... 🙁