I would prefer to use a different PK as well, but I am just looking into the problem for a co-worker so it's out of my hands onm the design issue. I plugged in the syntax you posted and received an error when trying to include the having kount > 1. Even with this removed I tried running it on just the TOP 5 and the processing took so long I eventually just cancelled the execution. So I guess I am still looking for suggestions. Thanks.