create shared CTE approach to handle both modern and legacy blocks within SystemC script(s)

[robjharrison]

atm use drop in commented code blocks for those using pre-2016 T-SQL as a compatibility work-around. would be better if we had a more CTE single approach to enable both needs without the duplication and to ensure consistency.