Comments by Mohd Arshad Malik (Top 2 by date)

Thanks a lot for the solution, but another problem with me is: I've to use this query on a very big datatable where lacs of new records are being generated everyday. On that table response time of query is in minutes.

Can you suggest anything so I could get results in optimal time.

Thanks & Regards