Thanks a lot Set. Yes, I guess I was not able to explain my requirements clearly.
I think because the underlying is a view, vwPriceListHistory, the query you suggested is taking very long to run. I will try your suggestion where there is a table rather than derived data Kind regards Bhavbhuti