I get the same errors

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 30

Incorrect syntax near '?'.

Msg 102, Level 15, State 1,...

Thanks a lot Gail,

Executed the query and returned the information very fast

Execution Plan from SQL2005

I sending The execution plan

Hi,

Thanks for your responses.

Executed the update statistics on Database; but query runs slow ...

The execution time of query on SQL 2000 is 6 seconds, on SQL 2005 23 minutes.

I sending...