An alternate to the row_number() function would be to create a table with an identity (1,1) column.

All we are trying to acheive is a sequential increase by 1, which the loop can pick up. During the insert ignore the Identity column.

Let me know if this helps.

Shanu