• The answer has the following text in it.

    7 rows where column d = three

    The wording of the answers were confusing as hell.

    They should be listed as

    7 rows returned, the last row has column d = three

    or something like that.

    I got it right, but I spent more time analyzing the answers trying to figure out what they meant than I did actually analyzing the question. I kept looking at the code, and saying to myself, "None of the rows repeat enough time to get the word three seven times, etc etc...

    I ruled out the insert error because the error that comes back is about inserting into column a, not b.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]