One thing I should mention is regarding the categories.  Most of the time when the report is run it produces the same set of categories.  However, it is possible that...

I figured out a cleaner way to use CASE

   (case when t2.metric1 is null then 1 else 0 end +
    case when...

Thank you both.

Is there a query I can run to find the collation for each table everywhere in my DB?  That way I can figure out where the problem is...

One thing I wanted to add.  I have been experimenting with my query to see how it can be optimized.  I have been trying the following approach:

Create temp table first

Create...

I forgot to mention...I am not seeing any performance improvements so that is why I am kind of thinking the index is not being setup correctly but that is just...

Thank you both for your feedback.  Issue has been fixed.  I will explain the fix so others can use it for inspiration.

The query uses multiple physical tables to store data. ...

One way to know is to add a parameter that defines the caller.  From the place where the procedure is being called, add the necessary parameter.

If you are going...

Thanks guys.  It works.

I ran the code and it gave an error:

Msg 214, Level 16, State 2, Procedure sys.sp_executesql, Line 1 [Batch Start Line 2]

Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

Do you know...

It already "knows"... That's what SYSTEM_USER returns. For example...

SELECT SYSTEM_USER AS WindowsAccount, be.*
FROM Bakery.dbo.BakeEvents be;

I know, looks really stupid, but the first column is the user...

Thank you for the reply.

Yes I mean column titles.  That is what I mean by "headers".  Sorry for the confusion.  Looks like dynamic SQL is a possibility.  No clue how...

Thank you for your reply.  I appreciate it.

I ended up re-doing the work and it is working now.  No clue what happened to the original version but it is ok. ...

thanks for the reply.

no such thing as dumb/silly question!  🙂

I haven't done anything different.  VS2019 keeps track of which package was opened and I have always been picking the one...

there is no such thing as a dumb question.

it is sql server 2019:

I downloaded and installed it.  Still not working.

What else do you suggest I try?