>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.