A few things to clarify...

1) It's the query that makes up the view that never completes. It churns along in SSMS. No records are returned while it's running, the timer is still running, etc.

2) When I run a query like "SELECT * FROM myview" I get results in about 20 seconds (different from when I run the actual query that makes up the view -- see point #1) and the query completes successfully....it's not that it continues running. GSquared -- I'm not using any WHERE criteria. In effect, it should just be running the query that's in the view.

3) There weren't any significant changes from yesterday to today. I updated statistics on all of the tables used in the view, which didn't resolve the problem. It's not my query/view, but I think the crux of the issue is that it was written inefficiently. I've worked with my coworker to rewrite the query and join indexed fields (which wasn't the case initially).

I think I'm OK for now, but I'm still a little puzzled as to why the view returned results yesterday (albeit after 15 seconds) and why today it required me to rewrite the whole thing. Moreover, I don't know why "SELECT * FROM myview" worked before I refactored the query that made up the view.

Mike