Thanks! The RIGHT operator was the trick I was missing. This is bound to be faster (and somewhat easier to read) than the CASE construct...

CAST(DATEPART([year],

This is almost exactly what I was hoping for...

Am I correct in thinking that this does not address the necessary sequencing of refreshes ?

...