Yeah i was looking on my.visualstudio.com/downloads and there are only Core installs for Enterprise edition. 
When searching for SQL Server 2016 Standard it lists 3 downloads 
SQL Server 2016...

You may have better luck posting this under Data Warehousing...

But that's a good question, i just tested it and getting the same result. You could change the parm...

Put your expression directly in the email task. It sounds like you've written the expression as a string into a variable then referencing that variable will just give what you...

Thanks Sue, appreciate the feedback.

I would first tell her about SQL and show how an Over clause works. That's a sure bet.... 

Here's an example
SELECT
ss.NAME
,ss.SPONSOR_NAME

not precisely every 6 months, that was just a ballpark. seems like during the year it may happen once or twice but no pattern.

OK thanks, I'll check into these, and by check into these i'll suggest this to the sys admins 🙂
The issue has happened on other servers, seems this randomly happens...

Ya, i kinda figured that. 
And yes the sys admins are on it. We rebooted the server this morning and everything is fine. 
I see a lot of posts saying...

EDIT: What actually happened is running refresh on a view changed a different view, different from what the post title says.

Created a script to find mismatching entries...

There's only a few of us here. These views have been in use for some time. 
So now i'm pretty sure that renaming views in SSMS is the culprit. 

Thanks Sue,
I understand the part about select * in a view (which we never use) and how changing a table won't be reflected in the view. 
But what happened...