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

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.