Okay, so I do have an additional question. Why use the specific WHERE clauses you've used? Why not test the NOT IN with specific values?

Why are you using...

I've never actually played with EXISTS / NOT EXISTS, so I should probably try it out and see if it helps with our ITD feed processes, which are taking longer...

So basically I am looking at a table to store all the possible combinations in.

I want to avoid a function if possible. I'd have to call it inside...

Thanks. I'll see if the Mac client works.

Not sure Azure Data Studio is going to work. He's doing schema development as well as coding and from what I...

And I get this in response:

we would like a simpler solution if possible.. Can you recommend a toolthat we can use on...

Thanks. I'll let our developer know.

Never thought I'd say this, but I need some Oracle help please.

https://www.sqlservercentral.com/Forums/2005273/Oracle-SQL-Developer-to-MS-SQL-Server

In the GUI, go to Query -> Include...

grumble, mumble.

Why is it the DBA's job to know A) all the business rules that the users either don't care to keep track of or can't keep track...

For future readers of this thread, I recommended it to SQLLearner22 on this other thread: https://www.sqlservercentral.com/Forums/2002068/SQL-server-Audit-Trigger-for-INSERT-UPDATE-DELETE