• Hello Jeff,

    very interesting article.

    Somehow it throws all my beliefs into the trash bin:

    1. The update method with variables is not explicitly supported by Microsoft

    2. The clustered index does not guarantee ordered results

    3. Order By in derived tables does not guarantee ordered results.

    Your "evidence" does not really convince me. It could be just a lucky day (or a lot of them) ;).

    If anyone would have some "official" documentation on these 3 topics, that would be great!

    Btw: Did anyone try the "Order By" Solution?

    It returns wrong results for me, but maybe did not copy the code correctly (somehow the linefeeds

    disappear with c/p).

    Best Regards,

    Chris Büttner