>>>Or simplify your query. What edition of SQL Server?
>>>
>>>
>>>>I need something more powerful :)
>>
>>the query is very simple join.
>>the issue is this:
>>on a sp
>>declare a variable table
>>uses it ... no problem.
>>
>>declare the variable table with a primary key and sql stop working.
>
>How many records you insert to variable table?
>
>MartinaJ

I know that with a few lines is not appropriate to add an index.

99% 10 records,
but in rare cases can be 10,000.
The procedure performs one operation of the operator ( save document ),
then pay price microsecond almost always
and gain a few seconds in the worst case improves
his experience in the use of the application.