I'd like to see a real test done on this issue. Im not a big fan of cursors, but they do have their place - usually more in an admin/maint role for scrolling through dbs, tables, etc, but sometimes they are the right tool. The while loop technique doesn't thrill me - it's barely set based and I would think would offer performance similar to a dynamic cursor since it queries the db once per row.

Andy