s.kandepi3 (8/16/2015)
I guess that would be possible if I am using just the view as my source .. by my source query is kinda complicated. the view gets joined with another and then there is the where exists condition with a subquery in it. I guess with this scenario, doing what you said is not possible, if i am not wrong. Let me know
I would be surprised if it were not possible.
--Currently you have something like this
select .....
from t1
join v1 on t1.Id = v1.id
--Which can be converted to
select .....
from t1
join ([enter v1 view definition here]) v1 on t1.Id = v1.id
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.