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?
A CTE might help. I never said it wouldn't. I said that I didn't see a need for a RECURSIVE CTE, which is a specific type of CTE.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA