I just came up with what I reckon is an awesome way of doing this. I build up what the name of the sproc should be (mp_dynamicsproc_param1_param5_order3) check to see...

This seems to be the route we're going down but we're trying to develop a tool to do smart code generation since we'd end up creating an awful lot of...

The problem that I think I've seen with the @ReorderPoint IS NULL OR ReorderPoint > @ReorderPoint is that you execute the sproc without the parameter, an execution plan gets cached,...