Hi,

Actually, I have increase my tempdb size to 100MB, even delete it
and restart my server, but my query still lock my other table.
How do I solve the problem as sometime the query work, sometimes
it don't, we are trying to change the SP way of coding too.
Thank

>>Hi,
>>
>>Thank for your advise.
>>Please kindly explain why the tempdb is giving the problem ?
>
>V,
>
>Your query contains two derived tables that are identical. SQL Server will choose an eager spool for one copy of the derived table so that both joins can pull from it in the query plan. The spooled table is stored in tempdb.
>
>Also, the intermediate results from aggregation functions are stored in tempdb.