• One more time

    Read the link in my signature on posting performance problems, also read the link on posting code and data.

    Update all your statitics, rebuild your indexes, post the execution plan as a SQLPLAN file, post your DDL of the tables involved, post the DDL of all indexes on the objects, post the definition of the store proc.