In this case, I typically add "OPTION (recompile)" ... Yes, it forces the server to come up with a new execution plan (adding time) but the new execution plan is based on the variables.
Best of luck!
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply