I'd write a job to put this info into table you have access to. You can update it daily if needed. Perhaps you can build a proc WITH EXECUTE AS....

I would urge you to test this with a bunch of data sets and be sure it works as you expect. Left (or right) joins can cause issues at times.

I believe that this is considered to be "syntactic sugar" meaning why should they do this when it's easy to do in code.

I disagree, but I can only...

There was a data migration, and a date stamped on those, which means that some older users (I think no longer active) got a lot of points awarded in the...

Code certainly is data, but we handle it differently.

I think people are just stuck on the idea an ALTER TABLE containing the changes because that's what we've had,...

The points seem weird because there was a migration from the old db to the new, and for some users this was done as a batch of points. I'm not...

I use tab completion heavily as well as Get-Help. However the help isn't well structured of written, IMHO. It reminds me of verbose, poorly structured man pages.

While...