Hi Abhishek,

Awesom, my problem got solved. I used table variables and Joined those tables with my query and that gave me my result with exactly the same Parameters and Where Clause. Also the performance was great. I cant believe it. Greate job Abhishek. Really wonder job done. Thumbs upto you and i specially admire your patience in this whole process.

I also learnt a wonder technique of writing better queries with SQL Server. I still have my point unanswered as why not the same query (leaving apart the table variables) didnt work at the first place. Can you guess what could be going wrong without the table variables. Also why the application hung indefintely ???

Anyways, once again thanks alot for your time and patience. Wonderful job done man...