The expected results are from 3 executions of the final SELECT statement in the loop:

areaChartValue

11, 10, 11

areaChartValue

212, 21, 22, 23

areaChartValue

334, 35, 31, 32

As for not able to run my cte,...

Good stuff. One suggestion, especially since you mention deploying to many servers. Remove the :setvar statements, and declare them externally (probably as environment variables if you're going to...

Try this:

Move the tables from the original databases to your "Something" database

Create synonyms for the tables in the original databases pointing to the the tables in Something

Your original databases will...