Please follow the link in my signature on posting performance problems and posting code and data for the best help.

First off I would get rid of the NOLOCK hints, unless you can live with the problems it causes. It is not a go faster switch.

Please post table definitions, index definitions, sample data, expected outcome along with the execution plan in a SQLPLAN file.