>OK, if I can ask - is there a reason you want to do it on a table instead of a view?
>Maybe I'm confused - but when you mentioned a CTE, I figured you needed to shape/aggregate the data beyond what the native tables contained.

Yes, some of those scripts are detailed. However, there seems to be an approach to workaround that.