Please find attached the modified code

The initial problem was caused by the following section in the code:

+ char(10)+char(13) +','

+',' + '

Increasing @query and @ColumnHeaders from nvarchar(4000) to nvarchar(max) resolved the remaining issues.

From what understand about your problem your only objective is to script the procedure with the output to be printed to text.

If you don't need to specifically have the output...