Using Select Statement Result as Variable and Passing it to CTE and Union All Results from CTE