Withthe data you've provided though, how do we know which col is model, which col is Company? Aliases' can't be referenced in a WHERE clause. Is it always:
col1 = ...

I have to ask; Is there a point when an MVP can come to the conclusion where it's a good idea to use the [master] database for user objects, and...

I wouldn't store it in the master database, no. Leave that database database as it is.

Without really knowing what the sp does, it's a bit of guess...

You can't use INTO, but you can define your table, and then INSERT:

CREATE PROC testSP AS
    SELECT 1 AS ID;
GO

CREATE...

I think the reasoning is you that you say that it works fine in SSMS, but you're not running it as it would be in SSRS. You EXEC is:

Duplicate of https://www.sqlservercentral.com/Forums/1916761/FOR-XML-could-not-serialize-the-data-for-node-because-it-contains-a-character-0x0000-which-is-not-al

That's not going to help, Luis! The idea...

Patches for SQL Server 2008 have been released, just waiting on 2012 and 2014, and SQL Server 2017 on Linux (possibly Docker too) now:
SQL Server 2008...