Anyone got any thoughts on this?

ha I knew that was coming. This is a very rudimentry example, but it gives you an idea of the issue

--create table #test (clientID int,contactID int,firstname varchar(255),lastname varchar(255),linkID int)

--insert into...

Great article. I have been trying to implement your ideas but have come unstuck with what I am doing. The issue revolves around implemenmting the key seek method when trying...