Shaun McGuile (7/1/2008)
the point of the exercise -...so all that is left is a table full of records which were duplicated at least once!
Misleading title though....;)
Jeff, Chris; It falls on deaf ears, yet again ๐
Hahaha this must look horribly familiar to you Shaun!
Bored now, I'm outta here. Learned some good stuff from Barry and Janine though. Top work!
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden