I am using the following script:
This brings back what I need with one exception it also brings back replicated records, which unfortunate.y is part of the design. I want to constrain the found set after this find to only the most recent record and name. I have a time stamp with date and time. I think it can be accomplished with a sql statement and I unfortunately am a "pre" novice to SQL. Can anyone point in the right direction, maybe with a starting point in SQL if that is the best way. Thanks.