I understand your thought about the problem with statistics and table variables. What would be your recommendation to solve the problem (if this is the problem)?
Impossible to say for sure without seeing the execution plans. It may involve inserting the @BusinessObjectDataGuids list into a temp table at the beginning of your stored procedure, though.
John
Hi John,
Here a the two execution plans.
/A confused one