I figured out how to get back in and it had saved my questions and answers.

Here was my first question and it's answer... note the lack of the MAXRECURSION option...

I'm officially "dead" with ChatGPT.  It never asked me for a password when I first setup my login.  I logged out and told it I forgot my password when I...

On second thought, I DO have a couple of interesting questions to ask it to see how it does... especially when it comes to answers that actually preform well.  And,...

The next question should be, "How can that be optimized for performance"?

I'm actually impressed with its responses that you posted above.  Impressed enough where I'm not actually going to try...

There is a certain amount of randomness built into its answers so if you ask it the same question at a later date it might give you a different...

To go along with with Grant so very correctly stated, there's the subject of this "little" thing known as a "Bad Page Split".  Rows are forced to go onto the...

Can you post the actual question that you asked it?  I'm curious as to how much it needed to know.

It is nice to see so many posts that offering different solutions, as well as the performance analysis.

Regarding the real case scenario in my situation, I would expect to...

That was going to be one of my other tests (and still will be to just to see what happens on different machines).  Like I said, this has turned out...

So it would seem!  Thanks, Jonathan.  I'll check later for things like CPU, Reads, Parallelism, and what happens with different indexes.

I take it that the PK you used was keyed...

You're saving me lot's of time, Jonathan.  What are the conclusions of your tests?

p.s. I ask...

@ jay-125866 ,

This thread has really gotten interesting with some great alternatives to the classic CROSSTAB method.

Can you provide some additional info about your real table?

1. Number of EventID's
2. Average...

Yep.  I suggested that above as a possible alternative.  Thanks for taking the time to write the code for it.

thank you All for valuable  directions. I will try to follow correct path as suggested.

one more question about locking, OFFLINE rebuild lock table for upcoming transactions. What about current...

That might be the way to go instead of using the CROSSTAB method on this one, Jonathan.