I'm stuck up in a situation where my sp takes longer time but the query takes lesser time. I went through all the posts mentioned in the T-sql Forum and i tried all the possible resolutions mentioned there but it did not help me.
I have a sp which has around 20 parameters and i tried assigning them to local variables as mentioned in various posts but that did not help me.
Could you please help me out with this problem?
View Complete Post