A backup and a restore followed by data cleansing would be a lot easier.

Otherwise, if you're moving subsets of data, especially since it's going to be relational data,...

If you mean something along the lines of, within T-SQL:
SELECT * FROM LastSelectResultSet
Then the answer is no. However, if you want to see what's happening on your server,...

The issue is, getting the exact detailed information isn't going to radically change the majority of your systems and it costs a lot more to produce. So, slightly better information...

What Jeff said. And in situations like this, execution plans are our friends.

I actually had to think about that one for a minute. Nice.

Oh, the love/hate relationship with PowerShell will only deepen, on both sides.

Yeah, that's an approach that will work and get done what you're looking for. However, I'd strongly suggest you take a look at dbatools. It's the best way...

This is a very complicated procedure and generally should not be the norm for most queries. I see a series of issues.

First thing I see is several DISTINCT...