KoldCoffee (5/1/2013)
please don't take the sample scripts to literally. They are over simplified, so my question is still... how to combine the results of the CTEs? Actually, Malleswarareddy_m already answered with working answer, but Chris had another angle and I wondered if it would work for me.
Best answer I have for this, don't over simplify your question. Provide us with what we need to give you a proper answer.