You're also confused about the meaning of recursion. Recursion is when one CTE refers to itself, not when one query references another. Even if you use a CTE, I see no reason to make it recursive.
Drew
but I would like it to dynamically take one value of date from Query 1 and then append the results .. I thought CTE can help. IHow can I then reform my query? use "in" clause?