[Rant]
After getting the supposed incorrect answer, I cut and pasted the code into SQL 2005 and then again into 2008. Ran each not less than 15 times and ALWAYS got 5 rows ...
Can anyone explain WHY or REASON for my results?
I do respect Ninja's_RGR'us knowledge and experience, but ah well
[/Rant]