Any ideas on how to turn the Clustered index into a seek?

swbarisax 2016-08-04 21:34:29

When we don't join to MEMBERPROMOTIONDETAIL the query runs in about 2 mins. With this join it returns in 30 seconds but causes too many rows to come back. Looking for ways to tune this query as is (Without the comments)