I created a proc in a db, granted rights to a role, added a normal (non sysadmin/non secadmin) to the role, and this seemed to work. You'd have to modify...

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...