Cheers! I just wanted to format the ugly looking SQL in @sql while someone was watching over my shoulder and then I had a light bulb moment - that it could be a possibility that BCP / cmdshell is having trouble having those LFs...... and there was the result.