• [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]

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]