I usually find the conversation stops when I say that I work with computers 🙂

You could add the view, stored procedures, etc. to a schema and grant the appropriate rights on that schema. As long as they always create/amend objects in that schema (easy...

The OP's project is teaching students how to query a database's metadata, interpret it and use that information to do something potentially useful. As a learning exercise that's fine. Would...

From my experience, most bosses don't want to be bad - it's just how they turned out. If you've got one that wants to be a bad boss, there's not...

Am I the only person disappointed by the topic contents after reading the title?

...and so, we have a perfect example of someone trying to help - and another person, not.

What use is a total for amounts that are in different currencies anyway?

I work in finance in the UK and, theoretically, it is compulsory for everyone to take a 2-week block of holiday each year (presumably so that anything dodgy they were...

Another option.

select Part_No, Part_Status
from TableName tnOpen
where Part_Status = 'Open'
and not exists (select 1 from TableName tnAll where tnAll.Part_No = tnOpen.Part_No and tnAll.Part_Status <>...

Could it be that the Email column in DB1 is shorter than the email address you're checking and it's being truncated?