Are you saying you want to navigate to the parameterized report URL so the report calls the proc w/ the parameter(s) already defined rather than opening report & setting parameters...

To handle one pair of consecutive CRLF, you'd use one replace. For additional consecutive CRLF, you nest additional replace statements.

DECLARE @crlf char(2) = CHAR(13) + CHAR(10)
DECLARE @doubleCRLF...

I assume SSRS is running on the client in question, since a remote server can't read client's Windows registry (clients don't even have to be Windows).

If so, one could use...

What version of SQL Server (@@VERSION)?

Using SSMS? Or another client?

Does it work using #test rather than test?

Are you in master or another database? Do other queries to same database work?

It...

The error is telling you that value already exists at the time of execution. You can confirm by executing

SELECT * FROM DR_Player_Upgrade WHERE PlayerID = 2930848 AND...

"after something like 500 messages have been displayed... yeah... I know... don't ask..."

Ouch. I'd like to see that. Not on my servers, mind you, but it would be interesting to...

Order is important. To be used, the first column(s) should match the columns in the predicate(s) of the query.

Analogy: A phonebook is fairly useless for finding a person if you...

FULLTEXT indexing/search: https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql?view=sql-server-ver15

Is performance bad merely because of the # of users, or because of the volume of data returned by a lot of users?  You probably want to look at indexing...

What data type is myColumn? What data type is the expression returned if myColumn is not null?

In this example, NULL resolves as an int if it's the only value:

            
January 13, 2021 at 2:39 pm
            
#3831967

            
            
                                                
        

When you say interview...

Probation? Exit?

Or actual meaningful dialog?

The issue here, as is often the case in development/deployment, seems not to be software/security, but process -- in particular a human step in the process.  In this case, a...

bcp utility: out is used for table or view source. queryout is required for query (e.g., stored procedure) source.

What does "7786" represent?  If it's a parameter of the stored procedure,...

Something like this:

   DROP TABLE IF EXISTS #xp_results;

   CREATE TABLE #xp_results 
      (
     ...

Can you change the data model? A more  EAV-like data model might be more appropriate in this case -- e.g.,

CREATE TABLE [dbo].[StatsDefinitions]

     ...