• SanDroid (4/25/2011)


    bitbucket-25253 (4/24/2011)


    Oh well, another question that does not rely on the workings of the database engine, but rather english comprehension.

    I would say you comprehended just fine.

    I would also say I do not see a concept or point being displayed by the question or it's explination. After furthur review...

    ...........................

    Seems that if you ORDER BY the name or alias of the column holding the NEWID() values and join to a #temp table of the records instead of the table you are deleting from (as you delete) the code always returns as I would expect it too.

    The other code would seem to never produce the same amount of joinable values to return...

    So why is "none of the above" the wrong answer?

    The behavior displayed here does not occur with temp tables, only table variables and NEWID(). That is what is being shown here.

    The "logic" of the code makes one expect that nine rows are to be deleted at random and they are not. THIS IS MY POINT 😀

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg