You can use:
REPLACE(YourJSONColumnOrExpression, CHAR(13)+CHAR(10), ;'')

This isn't a web support forum.   It's a SQL Server forum.   Not everyone here will know much about html and/or web configurations and settings.  While you know what "post a...

With that much query to review, I'd rather know ahead of time exactly what "assigning billing time" really means.   Why would there ever be work that's not in the "billable"...

This suggests that the files with the problem were generated "auto-magically", by whomever provides them.   Until you open them with Excel and then re-save them, you find it impossible to...

The problem here is that you are trying to do something that the connection via Linked Server (which is either OLE DB or ODBC), doesn't support doing.  You would be...

About the only way to automate this beyond just copying and pasting the data into Word, would be to use an SSIS package, where you can run that SQL code...

FYI, edited my query to remove unnecessary code, and fix resulting query formatting.   The reason that you can't use PIVOT here is because you are trying to pivot more than...

Perhaps this will do?
CREATE TABLE #temp1 (
    [Type]    VARCHAR(6)    NOT NULL,
    A        VARCHAR(4)    NOT NULL,
    B        VARCHAR(5)    NOT NULL,
    C        VARCHAR(14)    NOT NULL,
    D        VARCHAR(9)    NOT NULL,
    [Period] VARCHAR(7)    NOT NULL,
    Count1    INTEGER        NOT NULL,
    Count2    INTEGER
);
INSERT INTO #temp1
    (
    [Type],