Using Row_Number to pick the correct entry. This is an off-site link.  Please review our Terms of Service for additional information.

(Josef Richberg) There have been numerous occasions where I have to pick a one of two records out of a given result set, but how I determine which one has some unique rules. I have two examples of this and I show how I used Row_Number() to solve this.

Read this article...

comments powered by Disqus