• I don't like questions like this, and not because I got it wrong.

    It teaches me nothing about Sql Server or T-SQL (except debugging peculiar T-SQL), and to be able to answer it correctly, without cheating, you will have to manually write down how many rows are inserted in each run of the loop in order to keep track of the number in the meaningless "SomeNumberForDate" column.

    64% got it right. Yeah, right!! How many cheated and ran the T-SQL code?