ok, thank you very mutch.

I have other question related to the same problem.

I now can run the query, but in SQL Server 2000 this query executes in 2 minutes.

When i run the query in SQL server 2005 the query starts executing , but it don't stops.

It is traing to execute during several time 40 minutes and nothing yet (no results).

Can you help pelase?

thank you