When executing the stored procedure in Query Analyzer and sending the results to a text file, two sets of CRLF delimiters are written as row delimiters.

When exeucting the stored procedure from...

Thanks, Nick and everyone, for offering advice, help, and opinions. It seems that Begin..Ends are safety precautions for microsoft bugs. I think it is a pain to have to use a...

I had gotten around the problem using Begin .. End, similar to what was suggested (see below). But I just dont' understand why the problem occurs in the first place. Thanks to...