Search SSWUG.ORG:

DATABASES

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