Sean Lange (5/29/2015)
TJT (5/29/2015)
Sorry, solved - small issue on my endNo offense but if your view is like the pseudocode below your issue is only beginning. The performance of this kind of thing is shockingly awful.
create View MyNewView as
select *
from MyOldView
I saw a presentation by Jonathan Kehayias once where he showed a query plan that used views on views on views, etc and took 20-some hours to run. When he boiled it down to the 5 base tables, it ran in a few minutes. There's a serious lesson to learn from this - one that I took to heart.