Table definitions and index definitions as well please
Could you post the plan for just that query run in isolation, not that and every single other statement in what looks like a long procedure?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability