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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.