Ignoring the very valid point made my John_P, is there a reason you used a derived table instead of using a CTE?

;With SalesData (Color, SalesYear, SalesMonth,...

You can definitely do so. I use SSMS 2014 and all of our instances are 2014 except one that is an old 2000 instance and it works fine.

This of...

Here's a tool called Snippets Generator[/url] that I've been using that allows you to past the SQL and generate the snippet.

Modified it to put the results into a temp table with an additional column DBName so I can see which databases the orphaned users belong to and joined it to...

Is there a reason you didn't discuss deployment to the Integration Services Catalog?