Abhijit More (5/14/2013)
How do you want us to help? - need help to optimize the query.Can you drop this proc and never use? - not possible
If not, what are the real requirements? - requirement is to get all record that satisfy the join criteria
It's impossible to advise on something like that - too little information. - can u tell me what information do you need
Details!
I guess you should start from here: http://www.sqlservercentral.com/articles/Best+Practices/61537/