Maybe I can save you some time...

The following code works just fine but it has than nasty ol' Triangular Join in it.

  ALTER...

Ok... understood on the VLookup thing.  I forgot that it's a "range" calculation behind the scenes (it's been almost 2 decades since I've used one) that returns the row with the...

Good article.  One of the things you indirectly brought up was "reputation".  Not only does the DBA have a reputation but the company has a reputation.  I'm get angry when...

First, you should learn to post readily consumable data instead of just plain text.  Please see the first link under "Helpful Links" in my signature line below.  People will answer...

To be honest, I usually tell auditors "NO" when it comes to producing a full system ERD.  They usually don't have the need to know and it is a proprietary system. ...

It's funny how the term "incremental load" seems to have changed over time.  To me, an "incremental load" has always meant an "upsert" where items that already exist aren't reloaded,...