Yes... the QUOTENAME is supposed to be used just to make the sample data and isn't required to be posted.  It...

If you want better help, please post your example data as "Readily Consumable" data instead of a graphic.  See the article at the first link in my signature line below...

All that hype and it still produces incorrect answers to simple SQL questions that won't even execute.  And, it's method of posting (in one case) 30 different links to things...

My Dad told me when I was quite young that "Half of all that is written is wrong and the other half is usually written in such a fashion that...

Lordy... such companies exist but, man, they're very rare.  Most companies are like the one you speak of... they've adopted a horribly misshapen, grossly incorrect, interpretation of what "Agile" is...

Since you're new, please see the article at the first link in my signature line below if you want tested code.  For me, it's super rare for me to post...

That's a great idea, Jonathan.  Unfortunately and as the OP revealed in the post at the link below, the reasons aren't quite that simple.

https://www.sqlservercentral.com/forums/topic/not-like-alternatives-in-where-clause#post-4200971

Isn't this a job for "Replication"?  IIRC, it can even update the meta data in the target to match that in the source.

I'm not sure that I understand your question but, at face value, I have to say that "It Depends" on the privs you give "the business", whatever that is defined...

I just remembered a bit of trick code  using "Cascading CTEs" that I did about a million years ago for the exact opposite of what you're...

No.  But consider that the Model-T still does exactly what...

Heh... they really don't want this to be fast, do they? 😉

Instead of TempDB, how about a very small database...

Thank you, Jeff. The real data will have various reasons, but I need to exclude only three out of the rest. I can confirm now the pipe (|) can...

That would help for...

Ghads Jeff I know this is a quality...