Those are some great suggestions - thanks. I had toyed with the idea about possibly using a stored procedure previously but hadn't really explored it in any detail. ...

Thank you, Lowell. I am disappointed but not surprised. I had scoured the T-SQL reference I had prior to posting here and had not seen any reference to...

Thank you, Carl - those references look like they contain exactly what I need.

Thanks!

José

Thanks for sharing that, UB.

Regards,

José

I'm disappointed as well, but I can't say I'm surprised.  As others have stated it's really amazing that MS supported it as long as they did.

It's a shame, really.  I...

Thanks, Paul and wz700 for your suggestions.  That gives me a couple of things to try (and the excuse to learn some new utils!)

I appreciate your help,

Jose'

Thanks for the suggestion! That worked, although I had to bump the -w param up to over 8000 before it removed all the blank lines.  But my first thought regarding...

Thanks, Julian, for providing some perspective.   That is definitely good to know!  While writing my last post I was a little annoyed (could you tell?) because of the T-SQL limitations...

Thanks, WSquared, for your suggestion.  And thanks to everyone else for the ideas! 

Let me throw an question out there to anyone else who has had to migrate from Oracle to...

RDG,

That worked great.  Thanks!  You were correct -- it did leave one blank line but I think I can live with that.  I appreciate your help!

Jose'