My apologies to the OP for the thread hijack.

Should I start a new one?

"... ProcedureName WITH RECOMPILE means that the procedure's plan is never cached at all"

That's documented...

I expected the recompile to replace the plan or mark it obsolete, but that's not what I saw.

Running select...from sys.dm_exec_query_stats..Xapply sys.dm_exec_sql_text where object_name()='xxxx' and dbname='yyyy' showed me the plans before...

Hi.

I've run into situations where a non-optimal execution plan is created when the SProc is first compiled. The plans all look wonderful.

This is probably because I put the SProc out...