You working code link leads to a "Run this fiddle" link.  I cancelled from there.

Since you posted a graphic of the execution plan instead of an actual execution plan and you post no meta-data for the table and you posted no code, we're going...

The correct term is "PFM".  🙂

   WITH cteCombo(Combo) AS (SELECT TOP 1 is_combinable FROM #project_types ORDER BY NEWID())
 SELECT  project_types_ = string_agg(ca.project_type, N', ')
...

but most of the clients wants also using Manually written SQL statements using a functions we call "AdHoc Query" which basically sends the text as Query, and they can...

Remember the company that we're talking about...

It's the company that couldn't see the benefit of a series generator for more than 15 years and, when they finally did release it,...

I've not used or done a deep review of the article at the following link but, at a 60,000 foot level, it seems like it may be one of the...

Thanks for posting your discovery, Mark.

Thanks for the feedback.

Well, I am always using the execution plan, so I can understand what's happening, which indexes are used, which are not and I see the suggestions, but I have...

"Bumping" this thread so the first 2nd page post above shows up.

First of all, determine if all those "wonky views" are indexed views or not.

As for not having a DATE dimension, so what?  You've been here on SSC to know exactly...

Talk to your SAN folks.  SAN snapshots are perfect for this.

Hello,

Thank you for your kind response

In this scenario, the goal is to generate a report according to client requirements without using any reporting tools. The query output is directly...

Jonathan's code works only for 3 falculty members.  The op will "settle" for up to 20.

Is there a maximum number of faculty members per course code?

Also, please explain why you need to do this.  This is seriously antithetical to best practices and most practical applications...