By looking at the indexes of the columns involved in the join. Could you give us an example of what you're looking at?
If a column participating in a join...

Odd. When I tried it without any of the SendMail part, it worked:
DECLARE @Recipients varchar(max)  = 'polkadot@email.com',
   @Subject varchar(max)       = 'Submission at ',
   ...

Take the nice barometer to the building manager and ask him?
https://sqlsunday.com/2016/02/11/median-and-percentile-in-tsql/

Tried HAVING yet?

Like I just said - what you see in Access or SQL Server's relationships window is a visual REPRESENTATION of the relationships. Which way you drag or whatever to create...

No. It's just a visual representation. Use whatever layout you find easier to understand. (Not that it matters in 2019... database diagrams are gone.

Got data? (Create table scripts, insert scripts)

That article helps a lot! However can you tell how I can tell if the report is cached or updated by the report?
How do you deploy the shared dataset?...

For starters, I would rename the columns so they mean something. Databases where the column names are just about meaningless (and have the wrong data types) are a nightmare to...

This post is 8 years old. Why not start your own post?

And how do you propose to find out what changed by using ROW_NUMBER()? Even if you did...

just insert it. SQL Server handles the encrypting of the data before it gets written to the table.

Sure. Post the CREATE TABLE scripts too. Should be enlightening.

Then we can all see if you really needed a cursor to accomplish the task.

Oh for crying out loud. Why do professors teach you how to use cursors, but not in the proper place? I'd challenge the professor and ask why it can't be...

Maybe this article will help?
http://www.sqlblog.nl/dynamic-refresh-ssrs-cache-using-sql/

(Doesn't directly answer your question, but explains how to refresh the cache on a schedule)