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]

     ...

I don't know of a built-in way, nor an addin, that supports that. Seems like a useful option.

Here's an azure feedback suggestion you can vote on: https://feedback.azure.com/forums/908035-sql-server/suggestions/42237427-add-parameters-and-variables-to-configurable-fonts

GROUP_ID is a complex element composed of attributes. Value is an attribute of GROUP_ID, not an element.

Try this:

select
    pt.id,
    x.y.value('@Value','int') AS...

The following seems to work. Add TRIM() if desired fix space before comma.

DROP TABLE IF EXISTS #attributes
CREATE TABLE #attributes
    (
    Attributes...

I'm guessing it didn't.... You still aren't returning CALL_TIME in the subquery, but are trying to reference it in the pivot.

I believe that in your select, you would need to return...

Your subquery is not returning TraceyHarley5, RhonaCornwall5 , or CALL_TIME, so the select, function, & PIVOT have no reference to those columns. And the only columns in your subquery --...

homework?

Sample data that is failing? It sounds like perhaps you have a @TimeFormatted value that is only 1 character.

DECLARE @TimeFormatted varchar(max) = '2'
SELECT RIGHT(@TimeFormatted,LEN(@TimeFormatted)-2); 

Do you really have...