Have you filed a Connect issue? Can you share a link so that we can vote on it?

Here's a related issue: Include support for Calculated Columns on Columnstore Indexes[/url]

However, that's...

Thanks for the useful procedure.

One small correction:

I believe the "datas" CTE should use "ROW_NUMBER() OVER ( ORDER BY [Sample Time] DESC )". It is currently in ascending...

Thanks for the time and effort to produce this informative article.

One small thing I noticed is that this solution requires an assumption that a "missing" row in either destination...