Hi Luis Martin, I have tried executing query using with nolock. I didn't find any difference in the execution time. Thanks in advance.

Hi Satya, Thank you very much for the idea of executing query in stored procedure. This has reduced the processing time to 1/3rd. Query which was taking 6 minutes earlies is now taking around 2 minutes. Thank you so much. Could you please help me to reduce the processing time still more. Thanks in advance...

Hi Luis Martin, I have done in the suiggested way following are the results: Table 'Worktable'. Scan count 15570, logical reads 31139, physical reads 0, read-ahead reads 0. Table 'project_status'. Scan count 1, logical reads 366, physical reads 0, read-ahead reads 161. Table 'Worktable'...