Paul Hernández (6/30/2015)
Another detail,I am using with (nolock) in all the queries, including the lookup query
When I have had this problem in the past, it has usually been because there are duplicates in the source and I am doing a fully cached lookup. Are you certain that this cannot happen?