I added a case statement to a view using CTE's
Is there a way to diagnose and rewrite this more efficiently?
In order to troubleshoot what is occuring, you should post the execution plan of the query. Preference would be for the actual plan, but even the estimated plan would be useful. Just looking at this statement completely divorced from the rest of the query, it's just not possible to tell you why it's running slow.
answered Dec 28 '10 at 10:30 AM
Grant Fritchey ♦♦