Viewing 2 posts - 1 through 2 (of 2 total)
Thanks.
I "googled" parameter sniffing and found that some solutions had to do with creating local variables within the procedure that mirrored the parameters being passed in. That worked for...
June 23, 2008 at 1:52 pm
#833008
Yes, I have that in there already. It is located right after the BEGIN and just before any of the SQL executes.
June 20, 2008 at 1:43 pm
#832053