Manish,
I appreciate your attempt at simplification of the problem ... but you at least need to say that your real code has 10-12 tables up front because the code you posted showed absolutely no problem .
So far as the "waiting" message goes, yeah, we know you're waiting for a reply and what you posted didn't look real friendly...
...it's also called a "bump" and there's nicer ways to do that... maybe I'm just misinterpreting the brevity of the message
By the way... I think you'll find the real problem is the fact that you're using a view... lot's of times, the view must fully materialize in order to do an ORDER BY, even if it's not on a column in the view, or even just a TOP especially if the view is a non-indexed view that has aggragates.