I implemented a similar solution at work, logging the disk free space (along with database free space) to a table along with when it was recorded. Simple SSRS report...

This is very likely a case where the use of a statement level OPTION (RECOMPILE) will work perfectly and very quickly.

Heh... you, of all people, should know about "double posting".

Folks, no answers here, please.  Instead, go to the duplicate post and post there.  Thanks.

https://www.sqlservercentral.com/forums/topic/do-i-need-a-recursive-query-for-this-bill-of-materials-sort-of

I'd have to see more but I'd start with the idea that the "Starter" is actually a "Product" and that product becomes an "Ingredient" as if you bought it from...

I would use the following code to get 'last' Sunday. Seems a bit simpler than the current version.

SELECT DATEADD (wk, DATEDIFF (wk, 0, GETDATE ()), 0)...

Do not use DATEDIFF(WK) if you need for the first of the week to be based on any day of the week other than SUNDAY. It is ALWAYS based on...

Might be me, indeed.  I'm running some pretty secure connections.  If the connection doesn't prove themselves to...

And then there's the change in security or the deletion of a full site with no record but a trail of now broken links...

Secure Connection Failed

An error occurred during a...

I think your point about humans needing a change of pace rings true.

I know it sounds daft but I used to enjoy the excitement that surrounded a major...

I uploaded your picture to ChatGPT 4 and asked it to: "Write a SQL Server create table (table name: XXXRE60P) and insert script for this, make sure you...

I've discovered that the table is updated overnight and the issue re-occurs overnight.

If I run the code in the morning then it takes too long to complete. If I...

Thanks for the feedback, Steve.  The hard part was to make "Combo" available...

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', ')
...