Thanks that works.

As per ours DBA instruction's we were told to use NOLOCk on the query.

Is there any problem when we give NOLOCK in the View.

Thanks Chris.

That is the whole query. You are right it hits the performance. can you give some idea to write in the condition instead as a case statement.

Instead of a table variable.If i create a permanent table will it increase the perfomance here. May be I can clear the peramanent table after the end of the...

is it possible to redirect it to different drive(d:drive) rather than c -drive ?

Thanks Jack,