sjimmo (2/10/2010)
"it doesn't .. but you can create a sp instead when you want to use cte"Matt32 - The question was about a view.
Why do so many complain about a question that is not there? If the question is for a view, why do we not address it from that aspect?
I felt it is a good question. But Matt is not complaining here. He is giving an alternative to use CTE OPTION in proc instead of view.
SQL DBA.