So what it is doing is inserting the line break every 2033 characters. I am trying some work arrounds but no solution yet.

I was able to execute the code column by column as I have not figured how to include all column in one statement. It is still not removing the characters...

This is what I have but I am still getting an error. I am slowly understanding it.
Msg 208, Level 16, State 1, Line 106
Invalid object name 'dbo.Event_Total'.

Here is what I think it should be since the @score is the last column
Select *
From #Event_Total
REPLACE(@score, CHAR(13)+CHAR(10), ;'');
FOR JSON...

So I upgraded to 17 express so I can get the JSON output function. I then found a program that will create an app from the JSON output (Jasonette

also for some reason it is not sorting.
SELECT *
INTO dbo.Event_Total
FROM dbo.#Event_Total
ORDER BY CompNum

Ok, I took a look at the code and made some modifications and had some questions.

Here I needed to make a change for backwards compatibility
[code...

Ok, so the summer is finally over and everyone is back to school and I can devote more time to the script. I have been going over everything and I...

So I was looking at the PARTITION BY here https://stackoverflow.com/questions/9315070/trying-to-understand-over-and-partition-by. So I need to fix it so the ScoresID is a valid number and then do the sorting. The...

I added this sorting function and it is working but it seams to be sorting on some other value.
GROUP BY CS1.ScoresID, CS1.[Type], CS1.AG, CS1.CompNum, CS1.LastName,...

Having one table would be the best but one of the issues we have is the place order is not correct. Since the software does not include the age groups...