Sean,

I am very new to SQL server and do not know how to proceed.

Can you please help me to accomplish the same?

Thanks and Regards,

Ashvin

Hi Sean,

Thanks for your reply.

Is there anything that can be changed apart from no lock?

Regards,

Ashvin

I am not able to implement the dynamic search on my code, can you please help.

Hi GilaMonster,

Thanks a lot for the tips.

I do not know why nolock hint has been used. Accurate result? What alternative do you propose?

I have just been given this query to...