LoL fortunately this is years ago and the company is no longer...

I'm amazed both by what companies will and won't spend on things.  Million dollar budget for implementing a new CRM?  Sure, a few thousand to get a drain installed in...

/shrug Views at least validate themselves at creation time and if you do schema binding should stay valid.

Interesting, so they're less reliable than views.....

But what if I need to...

But what if I need to know the...

You specified an INNER JOIN.  That means SQL must check to see if a matching row(s) exist in the other table because, if not, SQL can't return the row. ...

As a bit of a sidebar, it will also seriously speed up code for things like REPLACE, especially for servers...

The moron knew last January that it was going to be bad(Covid), but he kept saying it would go away.  And his followers believe anything that comes out...

I don't agree with many things Trump has said, but that is probably true of many people. I do, however, know that I have...

Yes, I voted for Trump in 2016. First, he wasn't my first choice. Second, there was no way on Gods green earth I was voting...

I don't agree with many things Trump has said, but that is probably true of many people. I do, however, know that I have done better...

Yes, I voted for Trump in 2016. First, he wasn't my first choice. Second, there was no way on Gods green earth I was voting for an...

I don't agree with many things Trump has said, but that is probably true of many people. I do, however, know that I have done better under four years...

Don't want to turn this political, but thinking of you guys on the left side of the pond. I just finished re-watching the excellent West Wing...