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