Thanks Craig, I appreciate your thoughts and the speedy reply. If I'm reading correct the best performance might be:

SELECT...

INTO #Whatever

WHERE DateCriteria

then

SELECT...

FROM #Whatever

WHERE StringCriteria